How to use multiple cursors to loop through tables in stored procedure
Posted on 2007-11-20
There is probably a very simple solution, but I just can't figure it out.
I've got 3 tables I am trying to query:
Table 1 has flat data
Table 2 has 8-10 records for each value in table 1
Table 3 has record for each table1/table2 value combination
I need to know the proper syntax for looping through the values of table 2 for each value of table 1. My select query works fine. The current stored proc I'm using is working per se, but it's not producing the correct results since its not looping correctly.
Does anyone have any examples of using multiple cursors to loop through table values? Any direction you can give would be appreciated.