Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. UPDATE tt
  2. SET [stbk#] = tt2.[stbk#]
  3. FROM dbo.TestTable tt
  4. JOIN dbo.TestTable tt2
  5. ON tt.sttkt = tt2.sttkt
  6. AND NULLIF(tt2.[stbk#], '') IS NOT NULL
  7.  
  8. update yourtable
  9. set stbk# = x.stbk#
  10. from (
  11. select sttckt, stbk#
  12. where len(ltrim(rtrim(stbk3)))>0) x
  13. where len(ltrim(rtrim(yourtable.stbk3)))=0
  14. and yourtable.sttkt = x.sttkt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement