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 vote176 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote166 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote160 views1 answer
Mysql check if lowercase
SQL
1 vote200 views1 answer
Postgresql where datetrunc month and year equal
SQL
1 vote149 views1 answer
Drush sql-dump
SQL
2 votes163 views2 answers
How to run postgresql in linux
SQL
3 votes155 views2 answers
Truncate all tables
SQL
3 votes149 views3 answers
Mysqldump: couldn
SQL
0 vote154 views1 answer
Oracle session statistics
SQL
0 vote208 views1 answer
Ora 00001 error catch plsql
SQL