Yes. (In SQL Server, anyway) The 2nd SP inherits the tables that exist in the first. (as long as you execute the 2nd within the first, and not execute them sequentially from an outside context)
-----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 13:14 To: SQL Subject: ##TmpTables Can anyone tell me now, before I test myself and waste the time doing so, if I have a job that executes 1 sp, within this sp, i create a ##TmpTable, if I fire another SP at the end of the first, will the ##TmpTable still exist for use within the second SP? That make sense? Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
