Susan Zeller
szeller at cce.umn.edu
Tue Mar 4 17:13:36 CST 2003
Jim, I use UDF's for this. Results of a UDF can be used like any table. So, I massage data in a UDF which can receive parameters and then do the second manipulation in the sproc. UDF's are only avaiable in 2000 though. --Susan -----Original Message----- From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca] Sent: Tuesday, March 04, 2003 4:45 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Stored Procedures Hi All: Is there a way to use the results of one StoredProcedure to feed a second SP. The example I am working with is one SP to massages the data and the second one manipulates the data via Transpose/Pivot. TIA Jim _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com