note however, that temp tables are very high on resources. if possible try and use the table datatype (SQL Server 2000)
----- Original Message ----- From: "Raster, Tim" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 7:15 PM Subject: RE: ##TmpTables > 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:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
