Hi Kevin,
Thanks for pointing it out. I didn't have a chance to work with XML much in SQL 2005 yet. Can you tell me how is it better than OPENXML?
>Regarding the XML approach for variable lists...there are new XML capabilities in SQL 2005 that eliminate the need for sp_xml_preparedocument and OPENXML. You can basically "shred" the XML using new XQUERY capabilities to create a reusable table-valued UDF. (I covered this in a prior CoDe article):
>
<snip>
--sb--