Getting Individual Weekly and Unique Records

• mkravitz89

  Grasshopper

  Points: 10

  More actions

  September 21, 2018 at 1:10 pm

  #415667

  My database takes a snap shot of the customer forecast file on a daily basis.

  I am looking to create a report that tracks how accurate the customers forecast was to actual sales to load a more accurate forecast into the system.

  My problem is, I need to create a new table that does not have each days record.

  Below is what I'm trying to accomplish but need to do it through SQL as I have 3500 part numbers and forecast 20 weeks out.

  I need to first populate an interim table to uniquely identify the different values for each week. I need some help on how to identify the difference in the unique transactions based off Qty.