Post reply

How to use xsl to get this node formatted

  • June 23, 2009 at 2:35 am

    #103771

    *$199 SHARED

    24MTHS

    AS PER AGREEEMENT PRE MAY.

    *BAN: 645938292

    How can i use xls to format this node like this

    *$199 SHARED

    24MTHS

    AS PER AGREEEMENT PRE MAY.

    *BAN: 645938292

    Thanks in advance

  • June 23, 2009 at 1:55 pm

    #1014239

    I don't know if the following example will answer your question...

    DECLARE @xml XML

    SELECT @xml='

    *$199 SHARED

    24MTHS

    AS PER AGREEEMENT PRE MAY.

    *BAN: 645938292

    '

    SELECT

    c.value('.','varchar(30)')

    FROM @xml.nodes('ORDER_NOTES/TEXT') AS t(c)

    /* result

    *$199 SHARED

    24MTHS

    AS PER AGREEEMENT PRE MAY.

    *BAN: 645938292

    */


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 23, 2009 at 10:21 pm

    #1014414

    Thanks but

    sorry dude i was after an xsl stuff

  • June 24, 2009 at 4:19 am

    #1014514

    Patrick Ige (6/23/2009)

    Thanks but

    sorry dude i was after an xsl stuff

    You might wanna try http://tinyurl.com/l8cveg.

    Note: This is a professional forum. "Dude" is inappropriate and does influence the way I'll answer.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 24, 2009 at 6:10 am

    #1014571

    Sorry

Viewing 5 posts - 1 through 4 (of 4 total)

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