Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE
- --select * from
- [pec].[dbo].[PECActivations]
- SET STATUS =3 ,
- letterSentDate= getdate(),
- StatusMessage = StatusMessage +' '+ CONVERT(VARCHAR(19), GETDATE(), 20)+ ' Manually Sent'
- WHERE STATUS =40 AND
- CreatedDate> '2015-02-27'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement