Aren't you creating a local temp table with the create table statement? Will that table be available to the second query, or do you need to use #####cfid#_#cftoken#?
Spike > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED]] > Sent: 25 September 2002 15:22 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] Temp tables in SQL Server > > > Hi, > Anyone used temp tables in SQL Server in <cfquery>? > Anyone see anything wrong with doing below? > > <cftransaction> > <cfquery datasource="dsn" name="CreateTable"> > CREATE TABLE ##CFID#_#CFTOKEN#(WhateverID INT > PRIMARY KEY) > </cfquery> > <cfquery datasource="dsn" name="y"> > INSERT INTO ##CFID#_#CFTOKEN# > SELECT WhateverID > FROM Whatever > > </cfquery> > <cfquery datasource="dsn" name="x"> > SELECT * > FROM Whatever2 > WHERE Whatever2.WhateverID IN > ( SELECT WhateverID FROM ##CFID#_#CFTOKEN#) > </cfquery> > <cfquery datasource="dsn" name="DropTable"> > DROP TABLE ##CFID#_#CFTOKEN# > </cfquery> > </cftransaction> > > Cheers > Justin > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
