Neither suggestion works. The interesting (frustrating) thing about this is the fact that it fails only when included within a stored procedure. Running the two statements directly from...

I tried that option earlier; it yields the error "Incorrect syntax near the keyword 'as'.

I'm seeing the same error message for the following code:

CREATE TABLE #CDHToDelete

(

CDH_RecordID UNIQUEIDENTIFIER

)

INSERT #CDHToDelete

SELECT CDH.CDH_RecordID

FROM (IERP72..CommissionDefinitionHeader CDH

INNER JOIN IERP72..CommissionDefinitionDetail CDD

ON...