very nice work. thanks. we wrote this a few years back and posted a how to here: http://www.wijix.com/post/Bulk-Loading-XML-into-SQL-Server-2005-using-NET.aspx

We used SQLXML and bulk loaded it into sql. the...

it is in a ssis package that transforms data from one place to another and this is the format they wanted in the destination table. i just didn't know...

hahaha 😀 yeah... I couldn't figure out how to do that with Pivot but yes it works perfectly. I don't need speed... I just need a solution...

Thanks...

I was thinking I could use Pivot but I couldn't figure out how to use it properly.

[font="Courier New"]id val1 val2 val3 val4 val5

--- ---- ...