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

10 votes275 views2 answers
What is database
SQL
0 vote264 views1 answer
Sp in sql server
SQL
1 vote257 views1 answer
Drop df constraint sql server
SQL
0 vote282 views1 answer
Oracle string length
SQL
0 vote259 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote261 views1 answer
Mysql subdate
SQL
1 vote276 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote257 views2 answers
Nested query
SQL
0 vote255 views1 answer
C# mysql update statement set value to null
SQL
2 votes252 views1 answer
Set column to not null mysql
SQL