Anyone use Stored Procs return multiple results?

[nativespirits]

:confused: I have a stored procedure that returns more than one result set (mulitiple select statements). I am using ATL Server and have found an example from Microsoft called OnlineAddressBook. This example has helped me considerably with the OLEDB Consumer Template, specifically db_command and db_column. However, all though it indicates the possibility of moving thru more than one result set it doesn't give any clear example, such as syntax or whether or not binding can be manual or has to be automatic. I am sure this is a simple process but it is eluding me and I cannot find any examples or user posts anywhere on this. I have: [ db_command(L"{CALL dbo.spTranscriptGetStudents(?, ?, ?) }") ] class CGetStudents { public: // In order to fix several issues with some providers, the code below may bind // columns in a different order than reported by the provider [ db_column(1) ] LONG m_StudentNum; [ db_column(2) ] TCHAR m_LastName[DB_MAX_FIELDLEN + 1]; [ db_column(3) ] TCHAR m_FirstName[DB_MAX_FIELDLEN + 1]; [ db_param(1) ] DBTIMESTAMP m_asofdate; [ db_param(2) ] LONG m_schnum; [ db_param(3) ] LONG m_schyear; };

[nativespirits]

I think I solved this one also. At least it compiled, have to run it to test that it works. Basically bind the columns of the first result set to the db_command using db_column. Then in the receiving method check to see if you can .MoveNext record in the first result set if not use the .GetNextResult method to move to the next one. Heres the code: while (S_OK!=GetStudents.MoveFirst()) { GetStudents.GetNextResult(&numRecs, true); }