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...
declare @i int set @i=1 while @i < 100 begin if (@i)%2 =1 begin select * from TABLE1 end else select * from TABLE2 set @i=@i + 1 end