Home Forums Article Discussions Article Discussions by Author Discuss content posted by Nasir Mirza Using T-SQL to Transform XML Data to a Relational Format RE: Using T-SQL to Transform XML Data to a Relational Format

  • November 2, 2011 at 10:28 am

    #1402260

    Thanks for all of this it was exactly what I was trying to solve. I'm using the XQUERY and have all good results except one particular node format.

    The node looks like:

    <ProductID ProductNo="100086861"></ProductID>

    I'd be happy to get the full string but really only need that number.

    Using the XQUERY approach can that be done?

    Thanks for your time.

    P