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

5 votes375 views1 answer
Oracle source query
SQL
0 vote345 views1 answer
How to see password mysql vestacp
SQL
-2 votes327 views1 answer
Group functions in sql
SQL
1 vote317 views1 answer
Oracle character set
SQL
0 vote318 views1 answer
Find all tables where column name exists oracle
SQL
2 votes348 views2 answers
Mysql count rows returned
SQL
3 votes348 views1 answer
Only join in sql
SQL
0 vote321 views1 answer
Sql counter column
SQL
2 votes335 views1 answer
Mysql change data type of column
SQL
1 vote333 views1 answer
Copy postgres table from one schema into another
SQL