Smash125 (10/22/2013)
I have two queriesFor example
query1: select * from table1
query2: select * from table2
what I want both the queries run at the same time in the query analyzer. Please guide me how to do that
Are you trying to get parallel processing out of a stored procedure or are you just trying to play with scripts? There is a way to get parallel processing out of a stored procedure using jobs (call sp_start_job to start two different jobs) but it basically emulates what Mark posted. The proc would start each job and the jobs will run asynchronously.
--Jeff Moden
Change is inevitable... Change for the better is not.