how to use select union and loop
Solutions on MaxInterview for how to use select union and loop by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "how to use select union and loop"
Tim
23 Jan 2020
1CREATE TABLE #Temp
2(
3 <COLUMNS>
4)
5
6 DECLARE @position INT
7 SET @position = -1
8
9 WHILE(@position < 1)
10 BEGIN
11
12 INSERT INTO #Temp (<COLUMNS>)
13 SELECT * FROM mytable
14
15 SET @position = @position + 1
16
17 END
18
19 SELECT * FROM #Temp
20similar questions
join vs unionwhat is union in sqlsql select inside select sub querysql server union if table existunion vs union all in sqloracle sql union tables with different columnsselect distinct after joinsql unionunion all in sqlsql server union all exampledifference between join vs unionunion allunion sqlunion in sqlunion all left joinunion and union all in sql serversql 2 way of select unique your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful