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.
| Author |
Topic |
|
susan_151615
Yak Posting Veteran
99 Posts |
 Posted - 2010-07-20 : 05:59:20
|
| i need to comapare two dates i have framed like this.update IMP_IT_SOURCE set B.ITS_ROSTER_EXPECTED_DATE = dateadd(dd,(B.its_frequency),getdate()) FROM IMP_IT_SOURCE B,PWB_EXTERNAL_SOURCE_REF C WHERE B.ITS_ESR_ID = C.ESR_ID and C.esr_acronym='ADD'Its threwing error multi part identifier could not be boundsusan |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-20 : 06:09:35
|
quote:
Originally posted by susan_151615
i need to comapare two dates i have framed like this.update B set B.ITS_ROSTER_EXPECTED_DATE = dateadd(dd,(B.its_frequency),getdate()) FROM IMP_IT_SOURCE B,PWB_EXTERNAL_SOURCE_REF C WHERE B.ITS_ESR_ID = C.ESR_ID and C.esr_acronym='ADD'Its threwing error multi part identifier could not be boundsusan
Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
|
|
|
Multi part identifier could not be bound