There is a table called originalData that holds item specific information at a week level. There is a column called WeekTY.
Now I need a TSQL that does the following>>
There is another table called total end to end weeks that holds the number of total possible week values.
So, the sql simply looks for any combination of item + week that is NOT present in the originalData table and then adds them to the same table in this manner >>
if item1+Week2 combination is missing in the originalData table, the sql basically duplicates all the row data for the combination of item1 + week1 but put zeroes for weekTY column only
Please see the attached. Tab “originalData” has the original rows and the tab “addedRows” has the entire data with the added new rows for the missed item + week combination