I have a stored procedure which outputs two result sets.
Result set #1
col1 col2 col3
1 b test
Result set #2
col4 col5 col6
34 abcd 122
My first job is designed to get the Result set#1 and second job to get Result set#2.My problem is I get the results from Result set#1 in my second job also. I have checked the parameters, input/output columns and everything is according to Result set #2. Where am I not looking?Any suggestions??
Stored Procedure
Moderators: chulett, rschirm, roy