• Instead of using OpenXML you should look into XQuery.

    If you have trouble getting XQuery to work, please attach the XML file together with what you've tried and we probably can help you getting it to work.

    Edit: Regarding your code in prev. post: With the SELECT @strXML = N'' you set your xml document to an empty string and your variable @xmlDat is not used at all...



    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]