I have a stored procedure in which I have called another stored procedure [Let say I have parent stored procedure which is calling child SP]. Child stored procedure have a result set which have almost 10,000 records. How can I get it in the parent stored procedure?I have a stored procedure in which I have calle