Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 2 Answers
- 5536 Views
- I also Faced
- E-Mail Answers
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
Explain what are partitioned views and distributed partitioned views?
why would you call update statistics? : Sql server database administration
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Explain the stored procedure?
What is recompile sql server?
What is the meaning of resultset type_scroll_insensitive?
What is row_number () and partition by in sql server?
Which sql server table is used to hold the stored procedure script?
What is difference between join and natural join?
How do indexes help, types?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How to add code to the existing article (using improve article)?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
what is a transaction? : Sql server database administration
