How to use select union and loop

CREATE TABLE #Temp
(
  <COLUMNS>
)

 DECLARE @position INT
 SET @position = -1

 WHILE(@position < 1)
 BEGIN

    INSERT INTO #Temp (<COLUMNS>)
    SELECT * FROM mytable

    SET @position = @position + 1

 END

 SELECT * FROM #Temp

Source: stackoverflow.com

Similar codes

0 vote376 views1 answer
Sql show founctions
SQL
0 vote324 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
3 votes318 views1 answer
Mysql replace string in table
SQL
0 vote318 views1 answer
Sql offfset
SQL
32 votes346 views6 answers
Sql count where
SQL
0 vote305 views1 answer
Get duplicate entry sql
SQL
0 vote335 views1 answer
Print mysql
SQL
2 votes323 views1 answer
Columns Present in a table
SQL
1 vote328 views2 answers
Create table if not exist
SQL
1 vote345 views1 answer
Write a query to create an empty table from an existing table?
SQL