Chaks' Corner

Recently I had the necessity to do cross-tab report with the SQL Server data. First thin that comes into everybody's mind is to use the PIVOT functionality in SQL Server. But, being a programmer, I am not that fluent in writing and managing complex queries. I was looking out for some .NET implementation and found an excellent article here which helped me accomplish this task :)

I think this is a lot easier for me than writing SQL queries ;)

And here is performance comparison of .NET CrossTabs and SQL Server CrossTabs