Yes a temptable with two pound signs is known as a global temporary table. -----Original Message----- From: Bradford T Comer [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 2:14 PM 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:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
