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

4 votes136 views1 answer
Generate class from sql table c#
SQL
0 vote179 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote199 views1 answer
Oracle flush Shared Pool
SQL
1 vote185 views1 answer
Group_concat order by
SQL
1 vote243 views1 answer
Drop column if exists sql server
SQL
1 vote193 views3 answers
Update from select sqlite
SQL
1 vote186 views2 answers
Datetrunc hour snowflake
SQL
1 vote181 views1 answer
Moodle query item quiz
SQL
0 vote199 views1 answer
Mysql custom sort order
SQL
2 votes202 views1 answer
Sql server current date minus 5 years
SQL