Home Forums Programming XML The argument 1 of XML datatype method nodes must be string literal.plz help RE: The argument 1 of XML datatype method nodes must be string literal.plz help

  • September 16, 2012 at 2:08 am

    #1538319

    SELECT

    dense_rank() OVER (ORDER BY C.value('local-name(.)', 'varchar(50)')) AS 'SN',

    NodeName = C.value('local-name(.)', 'varchar(50)')

    , NodeValue = C.value('(.)[1]', 'varchar(50)')

    FROM @xml.nodes('/XML/Provider/*') AS T(C)

    actually the xml that i am fetching is very large approx 5mb in size with lots of child nodes.

    it is taking a lot of time..plz suggest alternative option with this query.