Skalarvariable muss deklariert werden

[alzaimar]

So vielleicht?

SQL-Code:

update @tpe_upl_references 
  set alias= HSP_OBJECT_1.OBJECT_NAME
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
WHERE  
    (hyp_planning.HSP_OBJECT.OBJECT_NAME =position) 
an  (hyp_planning.HSP_ALIAS.ALIASTBL_ID=14)