Challenging - SQL XML Task

• sanjai.nbs

  Grasshopper

  Points: 14

  More actions

  January 10, 2010 at 11:25 am

  #100707

  Guys,

  Please help me for this scenario. I should agree that I am just an beginer in the XML part...

  My question is, How should we specify a parameter of the node dynamically.. Say for eg....

  While (@iCurrRow <= iTotRow)

  Begin

  .

  .

  SET @MultiMessage.modify('insert (attribute MsgAddress{sql:variable("@mto")})

  into(/Event/Notifications/Message/Msg)[1]')

  End

  Once I have added the value of @mto in a new NODE-MsgAddress in msg[1], in the next loop I need this to be done in msg[2].

  But how do we specify the parameter for Msg node here...

  Please any information regarding would be very much appreciatable.. Thanks

• sanjai.nbs 57867

  Newbie

  Points: 7

  More actions

  January 12, 2010 at 11:01 am

  #1102608

  I got to know there is no such option to get the data in MODIFY(). SO I did that with some other method.. Thanks 4 everyone

• LutzM

  SSC Guru

  Points: 107049

  More actions

  January 12, 2010 at 11:59 am

  #1102654

  sanjai.nbs 57867 (1/12/2010)

  ---

  I got to know there is no such option to get the data in MODIFY(). SO I did that with some other method.. Thanks 4 everyone

  Excellent you found a solution. Would you mind sharing a more detailed explanation of "some other method"? It could help somebody else facing the same issue.

  ---

  
  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]