>I am accessing SQL Server data though OLE DB. I have a SPROC set up that returns two tables, but in CR I can only see 1 of those tables after I add the SPROC. Is this a bug, do I have to set something, or can this just not be done?
I did some googling, and apparently this can't be done. A SPROC can only return 1 SELECT to a report, and it is also recommended to SET NOCOUNT ON to make sure that the row count isn't the recordset returned.
What is the proper term to call a result set return from a SQL statement? So far I have called it table, recordset, result set, and SELECT.