I am using SQL 2012
I've been struggling with a problem of identifying movements week by week for customers and their products... I started another thread but I think it confused people...
There is data in SQL which I generate in a precount table (it is readied). It has all the weeks where there is some kind of customer/product change, we run this report each week for customer movement.
I will use one customer as an example because it's less data (there are 500,000+ records in the raw for all customers and all their week by week product movements):
This is the end result I want: