1 Reply Latest reply on Mar 18, 2013 8:23 AM by Steven Hawkins

    update of #TEMP table resulting in error

    virtualdatabase Apprentice

      Within a virtual procedure I insert INTO  a #TEMP table..

      Then I update it and finally return the contents of the temp table..

      When I query the proc I get this error:


      UPDATE #TEMP1 SET ReportEvent = (SELECT event_id FROM clinical_event AS ce2 WHERE (ENCNTR_ID = #TEMP1.encntr_id) AND (event_class_cd = 104) LIMIT 2)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates.


      It appears that the planner is thinking #TEMP1 is a RDBMS table...


      Any suggestions?