g_rose42 (9/14/2014)
Thanks for the reply. But I think that split function gives the values by row. i need it by column by.Even though if i convert into row by then i can use pivot but in the pivot i have to mention column names like param1,param2,... here column name may vary by the each item so cant use static.
If you need to dynamically assign the column names, there is only one option and that is to use dynamic sql. My first thought is to use the DelimitedSplit8K to parse the parameters, cross tab the results, then in dynamic sql create a table with the right column names, insert the cross tab'd results and select it from there.
😎