stored procedure with two result sets

Venkat1 · July 17th, 2007, 03:05 AM

Quote:

quote:Originally posted by joxa83
Nice solution.Thank You.

Hi My problem is same like that, But I am not able change the two results set Procedure. So Directly I can exec the Proc and Put into my temp tables? How can it do ? Please Give me reply. Stored Proc Creation is not in my hand

happygv · July 17th, 2007, 07:44 AM

I dont think you can accomplish that without editing the stored proc, unless the front end app is involved.

_________________________
- Vijay G
Strive for Perfection

Venkat1 · July 17th, 2007, 08:24 AM

Forgot to say I can not use front end app. I have to solve in Database stored procedure only

Venkat1 · July 18th, 2007, 01:02 AM

Quote:

quote:Originally posted by Venkat1
Forgot to say I can not use front end app. I have to solve in Database stored procedure only

Venkat1 · July 18th, 2007, 01:03 AM

Quote:

quote:Originally posted by Venkat1

Quote:

quote:Originally posted by Venkat1

Quote:

Forgot to say I can not use front end app. I have to solve in Database stored procedure only