Ryan Simmons
asked on
Find Missing Dates in List
In the attached list there is a column of stores and a column of dates. The dates represent the FirstDayOfWeek when the week is a Sat-Fri.
Some stores have missing dates where the store was not open for various reasons.
How can I show a list that displays the store and the date that it's missing in SQL?
MissingDates.xlsx
Some stores have missing dates where the store was not open for various reasons.
How can I show a list that displays the store and the date that it's missing in SQL?
MissingDates.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER