Skalarvariable muss deklariert werden

[Jens Schumann]

mit

SQL-Code:

update @tpe_upl_references  set alias= (SELECT Top (1) 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 tur ON hyp_planning.HSP_OBJECT.OBJECT_NAME =tur.position
                          WHERE (hyp_planning.HSP_ALIAS.ALIASTBL_ID=14) )

funktioniert es ohne Fehlermeldung.
Bin mir aber nicht sicher ob auch alle Datenensätze angezeigt werden.