i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on...
Answer Posted / vrinda
DECLARE @i int
SET @i=0
While @i<10
Begin
if @i%2=0
BEGIN
SELECT * FROM Table1
END
ELSE
BEGIN
SELECT * FROM Table2
END
END
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the architecture of ms sql reporting service?
What are window functions in sql server?
Can we use where clause in union?
What is key set driven?
What is resource governor in sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What is repeatable read?
How to filter out duplications in the returning rows in ms sql server?
How to scale out a federation by Sql statement?
What is the recursive stored procedure in sql server?
Explain steps of normalization?
What are horizontal and vertical scaling?
What is reference section?
How can you insert null values in a column while inserting the data?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration