DLookUp - 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)

DLookUp

Author

Topic

master640
Starting Member

6 Posts

Posted - 2008-03-18 : 11:39:37

UPDATE 13_Together_Dec_final_ICNs SET [13_Together_Dec_final_ICNs].PL = Right(Nz(DLookUp("PH_LEVEL_02_CD","dbo_DIM_PRODUCT","PIN = '")),2)
WHERE ((([13_Together_Dec_final_ICNs].flag)="delete"));

How would I convert this to SQL SERVER 2005

QAZAFI
Yak Posting Veteran

50 Posts

Posted - 2008-03-18 : 17:11:15

UPDATE 13_Together_Dec_final_ICNs
SET [13_Together_Dec_final_ICNs].PL =
Right(isnull(PH_LEVEL_02_CD,''),2)
FROM
dbo_DIM_PRODUCT
WHERE 13_Together_Dec_final_ICNs.flag="delete" AND
dbo_DIM_PRODUCT.PIN=''

master640
Starting Member

6 Posts

Posted - 2008-04-03 : 15:15:10

THANKS THAT WORK!
WELL HAD TO CHANGE THE CODE A BIT

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources