Forum Replies Created

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

  • RE: converting an XML file to a table

    Works perfectly! Thanks a lot!

    July 9, 2008 at 5:20 am

    #839987

  • RE: converting an XML file to a table

    hr_sn (7/7/2008)

    Assuming you are using SQL2K5 and you got this xml in variable called @xml of type xml, try this

    SELECTcalls.cLog.value('OperatorsName[1]', 'varchar(512)') as OperatorsName

    ,calls.cLog.value('Date[1]', 'varchar(512)') as Date

    ,calls.cLog.value('Transcript[1]', 'varchar(512)') as Transcript

    FROM@xml.nodes('//Call') as...

    July 9, 2008 at 4:28 am

    #839968

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