Post reply

Pulling Multiple Aggregates from XML

  • April 23, 2008 at 11:11 am

    #71154

    I have some XML (attached) and what I want is a SQL statement that will return 001 and 002 (ExcludedDriverId). The SQL I wrote (below), only returns 001. Any help?

    SELECT *

    FROM OPENXML (@xml_he, '//PersUmbrellaLineBusiness/BasicWatercraftInfo',2)

    WITH (

    ExcludedDriverId varchar(100) 'ExcludedDriverId'

    ) T1

    Thanks!

    Michael

  • April 23, 2008 at 12:19 pm

    #806226

    your xml did not show up

  • April 23, 2008 at 12:42 pm

    #806247

    Sorry 🙂

    Try it now, please.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply