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

1 vote235 views1 answer
Order by oracle
SQL
0 vote239 views1 answer
Oracle show grants on table
SQL
1 vote239 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
5 votes221 views2 answers
Oracle show procedures
SQL
0 vote227 views2 answers
Postgresql get long running queries
SQL
1 vote258 views1 answer
Trim leading zeros in sql
SQL
0 vote239 views1 answer
Monthly Birthday SQL Query
SQL
8 votes259 views1 answer
Racle create auto increment column
SQL
0 vote240 views1 answer
Sql server concat null
SQL
14 votes281 views5 answers
Set password for postgres user ubuntu
SQL