SQL Server 2k Determine Next Weeks Range - TechRepublic
General discussion
June 5, 2006 at 09:22 AM
parier

SQL Server 2k Determine Next Weeks Range

by parier . Updated 20 years ago

I am looking for a query that will,
upon executing, determine the date for next monday, even if today is monday, go to next monday.

This will eventually be for schedulers to determine whether or not employees are scheduled for next week.

This will be placed in a report, and users will have this as their “frontpage” and will let them know upon logging in, that they have employees that are not scheduled for next week.

The initial SQL (the one I am asking for in here) is what will start it all, then from these results, I can then pull deptartment/employees etc.

This discussion is locked

All Comments