Produce data extracts using day field for the Friday before the weekend
Clash Royale CLAN TAG #URR8PPP Produce data extracts using day field for the Friday before the weekend Using TSQL on SQL Server... I need to produce extracts that use a pay day column in a database that only holds the day number, for example 26 to produce extracts for the 26th day of the month with a twist if that pay day falls on a weekend then the data for that extract should be extracted the Friday before the weekend. Has anybody attempted this and able to offer some ways of achieving this through TSQL? Thanks Are you always running this for the current month? Otherwise I cannot see how any logic is expected to guess what month you are running it for. – MandyShaw 14 hours ago 1 Answer 1 I'm assuming you have the month and year available too, in wh...