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 vote113 views1 answer
Drop procedure sql
SQL
3 votes69 views2 answers
Coalesce mysql
SQL
1 vote256 views1 answer
Postgres upgrade to superuser
SQL
2 votes109 views1 answer
Convert series number to date in sql
SQL
5 votes110 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote121 views1 answer
Pass array parameter to stored procedure c#
SQL
1 vote110 views1 answer
Mysql sort by date column
SQL
5 votes125 views2 answers
Oracle rename table
SQL
1 vote124 views1 answer
Select users with same username
SQL
8 votes120 views2 answers
Alert table name mysql
SQL