Francisco Tapia
my.lists at verizon.net
Wed Mar 5 01:52:15 CST 2003
There is no way that I know of to do what you are asking in SQL7, viable workarounds include executing your sproc1, to execute a nested sproc that writes to a temp table and then refrencing the temp table from sproc1 long after sproc2 (nested) has executed. just a wag tho. -Francisco http://rcm.netfirms.com/ ----- Original Message ----- From: "Jim Lawrence (AccessD)" <accessd at shaw.ca> To: <dba-sqlserver at databaseadvisors.com> Sent: Tuesday, March 04, 2003 11:21 PM Subject: RE: [dba-SQLServer]Stored Procedures : Thanks Susan: : : Unfortunately, the client is running on SQL7. :-( : : Jim : : -----Original Message----- : From: dba-sqlserver-admin at databaseadvisors.com : [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Susan : Zeller : Sent: Tuesday, March 04, 2003 3:14 PM : To: dba-sqlserver at databaseadvisors.com : Subject: RE: [dba-SQLServer]Stored Procedures : : : 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