[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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com