Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...
Well, honestly, I'd like to have count, week, and year in the select....but have no idea how to do it as a cumulative count by week that resets each year, something like what you are suggesting.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results