More SQL help!

Teledude

Teledude

Teledude

Soldato
Joined
4 Dec 2003
Posts
2,847
Trying to run this…



update Members

set StaffDept = newaddresstoimport.StaffDept

where Members.AlternateId = 20870824



getting this back…



Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "newaddresstoimport.StaffDept" could not be bound.

Basically I want all the StaffDept ID's in the members table updated from the newaddresstoimport table where the AlternateId's in both match.

Just trying the above as a tester and no go yet :(
 
You need to be more specific then, you can't just put a random column name as the value in the set, it need to be either an explicit value or the result of another select statement:

Code: 
update Members
set StaffDept = (select newaddresstoimport.StaffDept from newaddresstoimport where newaddresstoimport.AlternateId=Members.AlternateID)
where Members.AlternateId = 20870824

The syntax might not be perfect but you get the idea.
 
Thanks :D

Im getting a wierd collation error now?!

Msg 468, Level 16, State 9, Line 1
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation.
 
You must log in or register to reply here.
Back
Top Bottom