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

3 votes372 views1 answer
Get current month last date in sql server
SQL
1 vote353 views1 answer
SQL: merging multiple row data in string
SQL
0 vote337 views1 answer
Changer un mot de passe mysql
SQL
6 votes346 views1 answer
Update left join mysql
SQL
0 vote344 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
7 votes357 views2 answers
Oracle foreign key reference table
SQL
1 vote346 views1 answer
Mysql best tutorial for beginners
SQL
0 vote339 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote334 views1 answer
What are the aggregate function in sql
SQL
0 vote400 views1 answer
Stratified sampling sql
SQL