Something like this???? If not post sample script to create the a dummy table with some sample data...DECLARE @YearWeek TABLE (ID INT...
In addition to apply With Nolock query hint (if your business logic allows you to read uncommitted records) ...how much time your query takes if you...
Separate names with a comma.
