• Lynn Pettis (7/21/2014)


    Eirikur Eiriksson (7/21/2014)


    Quick suggestion, don't use OPENXML, it is a depreciated feature and shoul not be used in new development. It is also much slower than XQuery/nodes methods, there are many examples on the XML forum.

    😎

    Did not know that. That's how I figured out how to parse an XML file I used for a current project. I was having too much difficulty getting XQuery to work and was on a tight timeline. Had to use what worked to get it done.

    Now moving on to the next phase where I am learning to use Power Shell to do the same thing I just finished doing in T-SQL.

    Pop over a sample, I'll peace together my most efficient XQuery/nodes approach. Gives me something to do on the commute.

    😎