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 vote341 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote336 views1 answer
Install mysql on bash
SQL
15 votes279 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote319 views1 answer
Postgresql print sessions using the database
SQL
2 votes245 views1 answer
Mysql admin u root p password change password
SQL
8 votes288 views1 answer
Oracle add months to sysdate
SQL
11 votes283 views3 answers
Sqlite3 create table from another table
SQL
0 vote313 views1 answer
Learnxinyminutes sql
SQL
0 vote355 views1 answer
Selecting specific day in colum sql
SQL
57 votes463 views6 answers
Sql alter table
SQL