How to browse resultset 1

[MrGandalf]

Hi,

I have a stored procedure that hase some SQLstatements. From time to time I want to see the resultset from a particular SQL statement. How can I achieve this?

 

[beechill4]

copy the sql statement into query analyser, and go to query (on the menu), results to text or results to grid

 

[MrGandalf]

I must be more specific.

The SQL statements in the storedprocedure rely on each other.

For example:

Select x into #temp1 from y ...
Select y into #temp2 from #temp1
Select z from #temp2

This means I have to copy all 3 to the query analyzer, an that's why I can't see any results.

 

[beechill4]

i would have thought it was still possible to copy and paste all three, highlight them , and execute them, sending results to grid/text?

 

[MrGandalf]

And you are right. I made a stupid mistake. All my select statements, select into temp table. Because of this I couldn't see any results....argh it's time to rest I think

Tx for the effort.