Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Select query in XML

    Try using the XPath test function. This seems to work:

    Select * from OPENXML(@idoc,'/MiscInfoResponse/PropertyDetail/Description/DescLine',3)

    WITH (LineNumber int '@d' ,

    Description varchar(8000) 'text()'

    )

    HTH - Nigel

Viewing post 1 (of 2 total)