Does anyone know how to work out what recordset was returned (IE: Field names & Data types) from within another stored procedure?
IE
SP 1 calls SP2 and needs to analyze its results...
NOTE: I realise that Output parameters can be used, but this is not an option here as all of the lower level (In this case SP2) stored procedures have already been written.. Now I need a way to analyze what they return.
