[ cf-dev ] Temp tables in SQL Server

[Justin MacCarthy]

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]