I have several parameterized SP's in place that pull data for me from an accounting system. After the initial data is pulled I have to add things to the data such as product descriptions, marketing descriptions, company name, credit status. I want to do this on the server because some of the lookup tables for these descriptions are 25000 to 50000 records.

Is there a way, after I have retrieved my data set, to pass that data set from the main SP to other stored procedures for modification? For instance I would pass my data to a SP that would add the product description and then pass it back, then I would pass the data set to another SP that would add the company name and pass the data back. Each of these small stored procedures would be the authority for the information it was adding and all data sets created would use this authoritative SP.

Ultimately what would go to VFP is the data set with all it's descriptions so all VFP has to do it print it.