Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.35 KB | None | 0 0
  1. UPDATE temp.dbo.KARTA_TMP SET
  2.         TYP_ID = CASE WHEN (select WAREHOUSE_ID from target.dbo.WLASCICIEL_KEY as A, temp.dbo.KARTA_TMP as B where A.WAREHOUSE_ID=B.WLASCICIEL_ID and A.SYST='DB') is null THEN null
  3.         ELSE (select WAREHOUSE_ID from target.dbo.WLASCICIEL_KEY as A, temp.dbo.KARTA_TMP as B where A.WAREHOUSE_ID=B.WLASCICIEL_ID and A.SYST='DB') END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement