The multi-part identifier "BACKUPSQLSRV3.trading.dbo.account.acct" could not be bound.

• nicholas.tci

  SSC Veteran

  Points: 274

  More actions

  August 7, 2008 at 8:51 am

  #196720

  I am trying to run this query for some time and it would not work, please help.

  select profile.acct, date_appl_sent, date_appl_recd,

  CONVERT(char(100),DecryptByKey (enemail)) as email , rtrim(firstname) as 'firstname',

  rtrim(lastname) as 'lastname', ltrim(convert(char(4),productcode)) as productcode

  From BACKUPSQLSRV3.tradecs.dbo.profile inner join BACKUPSQLSRV3.trading.dbo.account

  on profile.acct = BACKUPSQLSRV3.trading.dbo.account.acct

  Where Convert(smalldatetime,date_appl_sent) =

  DateAdd(wk, -2, datename(month,getdate()) +str(datepart(day,getdate())) +str(datepart(year,getdate())))

  and date_appl_recd = ' ' and date_reminder_sent = ' ' and date_pen_appl_signed = ' '

  Server: Msg 4104, Level 16, State 1, Line 1

  The multi-part identifier "BACKUPSQLSRV3.trading.dbo.account.acct" could not be bound.

  Thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 7, 2008 at 10:46 am

  #854603

  This is a duplicate post. I already answered this in the Administering forum.

  Please do not double-post.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon