Nice info in that link, wide tables are also completely new to me.

So even if I can pivot X number of columns I can only store them in upto 1024...

Thanks for the reply, figured this question was coming 😉

Its for building a fact table for an SSAS cube. I can't go into the solution is too much detail ....