[dba-SQLServer]Stored Procedures

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




More information about the dba-SQLServer mailing list