Handling Weeks that Overlap Years in a Date Dimension

(Ray Barley) Our business users want to report on some fact data aggregated by week. They define a week as beginning on Sunday and ending on Saturday without regard to the year. An example query would be how many employees were hired in each of the previous four weeks? While SQL Server has the D

Read More - Register for Free Membership