Cannot be bound - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Cannot be bound

Author

Topic

mikebird
Aged Yak Warrior

529 Posts

Posted - 2009-06-12 : 06:19:06

My latest annoyance. Ready to throw server out the window - shame no windows in server room... wot did I just say?!?!?!?

update prc_price_recs
set pr_sort_key1 = prc_price_recs2.pr_usrchar1
where prc_price_recs2.prcode2 = prc_price_recs.prcode

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "prc_price_recs2.prcode2" could not be bound.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-12 : 06:26:53

[code]UPDATE tgt
SET tgt.pr_sort_key1 = src.pr_usrchar1
FROM prc_price_recs AS tgt
INNER JOIN prc_price_recs2 AS src ON src.prcode2 = tgt.prcode[/code]

E 12°55'05.63"
N 56°04'39.26"