February 11, 2005 at 7:11 am
Hi,
In oracle sql work sheet, when we execute the query the results are appended to the worksheet result pane instead of overwrite it. Is there a way I can do this in sql server also so that i can at all the previous results.
Thanks,
Sridhar!!
February 11, 2005 at 8:54 am
Hmm, besides making 2 separate sql statements and running both at the same time I don't think it's possible. You might maybe run a union on those both statement so that you get only 1 result... but I doubt it's gonna do what you want it to do.
February 11, 2005 at 8:57 am
I just make use of the MDI interface in QA for this. If I have results in a grid, and I want to run a 2nd query, I CTRL-N, open a new window and run the 2nd query there.
February 11, 2005 at 2:31 pm
run the two queries as batches like:
select * from tbl1 where xx = 'yyyyy'
select * from tbl1 where xx = 'zzzzz'
you should get as many resulsets as batches you send!
HTH
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply