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 vote120 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote106 views1 answer
Comma seperated join mssql
SQL
15 votes98 views7 answers
MYSQL
SQL
1 vote97 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote94 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
4 votes138 views2 answers
Sql select except null
SQL
6 votes132 views3 answers
Rename column ORACLE
SQL
2 votes104 views3 answers
Copy data from one table column to another table column in sql
SQL
7 votes103 views2 answers
What is sql clause
SQL
7 votes102 views1 answer
Minecraft forge server host
SQL