Post reply

Retrieving a text as xml and display in table

  • March 16, 2007 at 2:16 am

    #68090

    Hi All,

    Please help me Guys!

    I have a field say "xmlcol" in sql server database of type varchar. But it has the xml data in text format. i have to retrieve the xml data from the text and display in tabular format.

    Is it possible in Sql Server Reporting Services?

    Any body there knowing this?

    Thanks and Regards,

    Thiyagarajam

  • March 16, 2007 at 3:22 am

    #695403

    Thiyagarajam

    I think if you look up sp_xml_preparedocument and OPENXML in Books Online, you will be able to find a way to achieve what you're looking for.

    John

  • March 16, 2007 at 6:48 am

    #695437

    Hi John,

    Its really working perfect!

    Thank you so much!

    Bye..

    Regards,

    Thiyagarajam

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

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