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 vote283 views1 answer
Psotgres multiple values
SQL
1 vote313 views1 answer
Import sql file from laravel
SQL
0 vote273 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote269 views1 answer
Select 1 from orders
SQL
0 vote263 views1 answer
Postgresql alter column nullable
SQL
0 vote252 views7 answers
10 random questions use python and SQL
SQL
0 vote306 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote269 views1 answer
Mysql default timestamp value to be current timestamp
SQL
2 votes253 views1 answer
Oracle create directory
SQL
0 vote274 views2 answers
Collation in sql
SQL