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

2 votes145 views3 answers
Current month mysql query
SQL
1 vote159 views1 answer
Delete dublicate rows sql
SQL
0 vote244 views1 answer
Sql insert exemplo
SQL
1 vote182 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
3 votes143 views1 answer
Sql server version query
SQL
0 vote139 views1 answer
Select other columns with distinct
SQL
0 vote164 views1 answer
How to define a non primary composite key in sql
SQL
1 vote142 views1 answer
Sql server datetime vs datetime2
SQL
0 vote142 views1 answer
Composit key in sql
SQL
0 vote142 views1 answer
What is the difference between now() and current_date()?
SQL