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 vote286 views1 answer
SQL Server Enterprise
SQL
0 vote279 views1 answer
Last date for each user sql
SQL
0 vote205 views1 answer
C# execute transact sql
SQL
0 vote215 views1 answer
Postegresql update to null
SQL
9 votes208 views3 answers
Find all tables with column name
SQL
18 votes234 views6 answers
Laravel form validation
SQL
0 vote192 views1 answer
Select from another database
SQL
1 vote187 views1 answer
Ilike for date postgres
SQL
0 vote181 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
2 votes234 views5 answers
Tablespace ORACLE
SQL