Create a "calendar table" and calculate this once. Then you can use it for your query.
See:
https://weblogs.sqlteam.com/dang/2010/07/19/calendar-table-and-datetime-functions/
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I need your help in calculating financial weeks based on below rules:
I appreciate your help.
Create a "calendar table" and calculate this once. Then you can use it for your query.
See:
https://weblogs.sqlteam.com/dang/2010/07/19/calendar-table-and-datetime-functions/