That's great! No unpivot required.

Thanks heaps pietlinden! 🙂

Hi @pietlinden

Appreciate your time looking into this.

1. Load date is not related to Week 1 or Week 2. Load date is just there for records as in to...

Thanks Frank!

That helped heaps.

Hi @Pietliden,

Thanks. Much appreciated.

I will leave this open for a bit to see if someone has a better solution. I was hoping that there would be some functionality in Azure...

Hiya Jeff,

Apologies for the delayed response. I absolutely agree with you however, max rows that will return in prod. is only 1200. So, i think I am able to get...

Thanks - that's perfect!

Thanks Thom but, I still get the duplication in the last column promo group. How can I only have unique promo groups as a result? Thanks a ton,

Thanks heaps! That works 🙂

Thanks Erland!

And the precision & scale as well please! Thanks

Hi Pietlendin,

Thanks for your prompt response.

Yes you are correct I am NOT using View as a Schema name. It was just to give the audience a brief idea that the...