Checking that today's date is the first Monday of the current year

If today is the first Monday of the year, the start date from MAKEDATE will be greater than the end date calculated using DATE_SUB, resulting in an empty result set.

To resolve the empty output issue, consider modifying the sProc to check whether today's date is the first Monday of the year and adjust the date range accordingly.

Read at SitePoint Forums | Web Development & Design Community