Posted by: secretkiller August 30, 2010
Login in to Rate this Post:
0
?
- Update Table1Set new_batChase1Req1Mailed
- = Case When Coalesce(new_batChase1Req1Mailed,new_batChase1Req2Mailed,new_batChase1Req2Mailed) is null
- then getdate() Else null End,
- new_batChase1Req2Mailed =
- Case When new_batChase1Req1Mailed is not null then getdate() Else null End,
- new_batChase1Req3Mailed =
Case When Coalesce(new_batChase1Req1Mailed,new_batChase1Req2Mailed) is null- then getdate() Else null End
- where new_battelleId = thisView.new_battelleId