Monday, September 1, 2014

SQL Server filled out empty rows 



select a.ItemNum,  case when a.remarks ='' Then b.remarks else a.remarks end
from #sample1 a
/*Left outer join #sample2 b*/
Right outer join #sample2 b
On b.ItemNum = a.ItemNum
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)