[dba-SQLServer]Stored Procedures

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