I have a SPROC1 which sends results back to the calling .asp program via a select statement like:
Select distinct MessageID, MessageDate from #Messages order by MessageDate desc;
I'd like to write an SPROC2 which executes SPROC1 and then can loop through records returned from SPROC1.
What would the syntax be to call SPROC1 and then loop through the results?
Thanks in advance.