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'
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'
Comments