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

8 votes147 views2 answers
Default sql server port
SQL
4 votes128 views4 answers
Remove duplicate old value in mysql
SQL
0 vote107 views1 answer
Mysql date time string format python
SQL
0 vote107 views1 answer
How to find date from date table in sql
SQL
18 votes61 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote112 views2 answers
Foreign key set 0
SQL
2 votes138 views2 answers
Postgres change owner of schema
SQL
0 vote146 views1 answer
Capabilities of sql select statements
SQL
0 vote103 views1 answer
Groupby error in mysql
SQL
0 vote100 views1 answer
Postgresql create user roles
SQL