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 vote134 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
8 votes123 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote118 views1 answer
Join creating duplicate columns sqllite
SQL
1 vote266 views2 answers
Sql unique rows
SQL
7 votes117 views3 answers
How ot change name of column mysql
SQL
0 vote132 views1 answer
Datagrip execute procedure
SQL
0 vote138 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote120 views1 answer
Postgresql interview questions
SQL
0 vote121 views1 answer
Sql server manager close connection
SQL
2 votes123 views1 answer
Mysql virtual column
SQL