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

• martin.kerr 34088

  SSCommitted

  Points: 1752

  More actions

  November 2, 2011 at 5:31 am

  #245435

  Hi All,

  i am trying to execute this statement:

  begin tran

  update Attributes

  set EntityId = dbo.Entity.GlobalId

  where Attributes.DQUID = dbo.Entity.GlobalId

  but am getting this error:

  Msg 4104, Level 16, State 1, Line 4

  The multi-part identifier "dbo.Entity.GlobalId" could not be bound.

  Any help much appreciated

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 2, 2011 at 5:34 am

  #1402070

  You don't mention that table anywhere so the server can't know what you're talking about.

  You need to add an inner join in the from clause.

• MuraliKrishnan1980

  SSCrazy

  Points: 2497

  More actions

  November 2, 2011 at 6:45 am

  #1402111

  [font="Tahoma"]

  Try this one

  update Attributes

  set EntityId = Entity.GlobalId

  from Attributes

  Join Entity

  on Attributes.DQUID = Entity.GlobalId

  [/font]