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=0 While @i<10 Begin if @i%2=0 BEGIN SELECT * FROM Table1 END ELSE BEGIN SELECT * FROM Table2 END END