With 90 tables to figure this out for, it's not realistic to think that we could easily determine the best methodology.   However, one option I can suggest strongly that you...

Bad idea.  Squared.  If you used an SSRS Matrix in your report (assuming you are using SSRS), then you would never see that column if you never had any values...

I get the feeling there's a disconnect between what you want to do and how one does it.   You can not just treat an entire database as if it's a...

Without the actual XML that you fed into your code, we have no way to see the same results that you got.   I also don't see how the SQL Server...

Just how much data is in 18 million rows of 168 columns ?   What speed is the network path between the servers?   How much RAM and CPU is on the...