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?


      Thanks