ankit.gupta1 (10/15/2013)
The problem with cross tab or pivot method is that we have to hard-code total number of columns.Here in the table t2 there may be any number of rows for a given name.
How do I handle that?
Even though I prefer to do stuff like that in the application layer, I'd use the DynamicCrossTab approach as referenced in my signature, if needed.