Thank you all , yes it worked as expected.

Data is not in any order either Col1 nor Col2, Data might change in Col1 & in Col2

Any thoughts or suggestions on the above

Data is not in any order either Col1 nor Col2, i have taken this as an example in the real time it won't be the case.

Data can change in Col1...

It is working fine, but it is taking lot of time to do the process.

Data is around 20 Billion records...

As per the above example Combinations of Data, Empid ,sales by week.

I am stuck here with this now.. As i need to add few more columns like EmpID, DepID. And hence it is failing..

I tried different partition by in the order...

I am not getting the blue lines.. that is what i was expecting vs what has i received.

what i received is on left vs what it was suppose to be...

Here is what i see when i add the new columns to select statement  which is not having value for 1234,A with Zero.

Thanks Phil, I believe this one is coming close, But what will happen if i have to two more columns DepartmentID and EmployeeID to my #table data.

FROM Create Table #Table...

Thanks Phil.

It was not working as expected as when have the below record then it is behaving differently. It is not showing up for Week 18.

From :

UNION...

Thanks Phil.

Here i have added a new value for C for week 19 and i am not suppose to get the Zero(0) for month 3 for week 11 as we...

@Phil, Do you have any suggestions ?

Any thoughts or suggestions

No , it should not be the case.

But it is possible where in the current load it may not come, but where as it can again resume in May month.