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 vote117 views1 answer
Enable sql server full text indexing
SQL
23 votes116 views4 answers
Sql server substring
SQL
0 vote119 views1 answer
Postgresql print sessions using the database
SQL
0 vote128 views1 answer
Mysql equivalent decode oracle
SQL
0 vote120 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote94 views1 answer
Output to file mysql
SQL
0 vote149 views1 answer
SQL-Arten
SQL
1 vote106 views1 answer
Oracle get current schema
SQL
1 vote94 views2 answers
Mysql type conversion
SQL
2 votes106 views1 answer
Alter table add multiple columns postgresql
SQL