Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE [DiaryData] SET [Booked] = DATEFROMPARTS ( YEAR([Booked]), 11, 30 ) WHERE DAY([Booked]) > 30
- UPDATE [DiaryData] SET [Booked] = DATEFROMPARTS ( YEAR([Booked]), 11, DAY([Booked]) )
- UPDATE [LabourData] SET [DateTo] = DATEFROMPARTS ( YEAR([DateTo]), 11, DAY([DateTo]) )
- UPDATE [WipData] SET [Created] = DATEFROMPARTS ( YEAR([Created]), 11, 30 ) WHERE DAY([Created]) > 30
- UPDATE [WipData] SET [Created] = DATEFROMPARTS ( YEAR([Created]), 11, DAY([Created]) )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement