SQL Server can easily create cross tabs. It's called a pivot. If I understand your need correctly, it will be faster to do it in SQL server vs. using C#.


>Hi Craig,
>
>In our payroll application there is a large number of possible money and time categories. We keep a list of all those categories in a table. There is another group of tables for which we want to store detail columns (which are a subset of the categories described above) in a cross-tab arrangement. We want to write generic code to build the cross-tab cursors and to update the corresponding base tables when required.
>
>I think the best way to accomplish this reasonably quickly is to keep selected cursors small and to use stored procedures so that all processing happens in the database server. Since the generic code required with be complex, I don't think the stored procedures should be written in Transact-SQL but in C# using CLR + SqlServer integration.
>
>Since I am new to these tools I would like to ask you and the other experienced .NET developers here: Do you think the C# / SqlServer combination is capable of doing the described job well? Also, do you know if someone has already written this code or something similar?
>
>Thank you very much,
>
>Alex
>