Kevin Wilkie is looking forward to the weekend:
Sometimes, you’ll be asked to show the next Friday after a given date in a report. Sometimes, it’s the next Monday. Let’s work thru how to do it in both SQL Server and Snowflake for comparison…
Read on for some techniques Kevin uses. I’d just as soon drop in a calendar table and use it to track the appropriate day.