Work with query results inside a stored procedure

[Yevgeny Efter]

Hello! I need to write a stored procedure that will make a query, and then return a value depending on the query result. My question is how can I store the query results inside the stored procedure for me to be able to examine them and then return an appropriate result? Thanks in advance!

Have a nice day!

[Rob Philpott]

You want to store your query and then query that in a stored procedure? Can you not just do a bigger better query? You can use cursors to do iterative stuff if need be but its best avoided.

Regards, Rob Philpott.

[Ali Rashid]

Declare a temp table and save the result set inside that table. Make sure to drop it before you exit the stored procedure.

[Yevgeny Efter]

Can you give me a simple example? I would be very thankful...

Have a nice day!

[Yevgeny Efter]

Found an example by googling. Thanks!

Have a nice day!