xsd transformation on a st.Proc.

• keyser soze-308506

  SSChasing Mays

  Points: 630

  More actions

  June 23, 2008 at 6:00 pm

  #129670

  hi

  i have a schema collection

  that describes a mapping to a relation data

  that is, an "xml view"

  i understood, and tested successfuly

  how to transform the data using "templates"

  with SqlXml 3.0

  i can get, on a browser

  the "implicitly" mapped result ;

  but i need to do this transformations/mappings

  at the server, we say, on a stored procedure

  the problem is : i have a table with a xml column

  containing xml data of different subtypes (of a parent Type),

  i need to get "implicitly" additional information

  for each xml row, depending on its specific transformation...

  that is, for a xml type X

  i need to "join" with some tables

  but, xml type Y i need to join other tables

  and retrieve different (xml) data

  i need to do this inside a st.proc

  i think this is possible with mapping elements

  please, Jacob

  can you guide ??

  please tell me i need to explain better

  thanks,

  Hernán

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  June 23, 2008 at 7:33 pm

  #833107

  You need to move this topic to a more appropiate Forum.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]