Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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...

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


Please Help Members By Posting Answers For Below Questions

What is the architecture of ms sql reporting service?

1023


What are window functions in sql server?

1065


Can we use where clause in union?

1122


What is key set driven?

1007


What is resource governor in sql server?

1046


How we create SQL Server 2005 Reporting Services ? Give me Sample

2042


What is repeatable read?

1090


How to filter out duplications in the returning rows in ms sql server?

1210


How to scale out a federation by Sql statement?

118


What is the recursive stored procedure in sql server?

1073


Explain steps of normalization?

1061


What are horizontal and vertical scaling?

172


What is reference section?

1053


How can you insert null values in a column while inserting the data?

1339


I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1131