Skalarvariable muss deklariert werden

[Jens Schumann]

Hallo alzaimar,
vielen Dank für Deinen Tip.

SQL-Code:

update @tpe_upl_references  set alias= (SELECT  HSP_OBJECT_1.OBJECT_NAME AS ALIAS 
                          FROM   hyp_planning.HSP_OBJECT AS HSP_OBJECT_1 INNER JOIN 
                                 hyp_planning.HSP_ALIAS ON HSP_OBJECT_1.OBJECT_ID = hyp_planning.HSP_ALIAS.ALIAS_ID RIGHT OUTER JOIN 
                                 hyp_planning.HSP_OBJECT ON hyp_planning.HSP_ALIAS.MEMBER_ID = hyp_planning.HSP_OBJECT.OBJECT_ID 
                                 INNER JOIN @tpe_upl_references ON hyp_planning.HSP_OBJECT.OBJECT_NAME = position
                          WHERE (hyp_planning.HSP_ALIAS.ALIASTBL_ID=14) )

Das Statement erzeugt innerhalb der Stored Procedure beim Versuch eben diese anzulegen folgende Fehlermeldung

Code:

Meldung 209, Ebene 16, Status 1, Prozedur ListTree3, Zeile 43
Mehrdeutiger Spaltenname 'position'.