How can I generate XML and apply a style sheet in t-sql?

• oradbguru

  Hall of Fame

  Points: 3126

  More actions

  November 29, 2012 at 6:07 am

  #1563723

  Ah, that is on the first page. Sorry I missed that. Thank you!

  🙂

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  November 29, 2012 at 6:19 am

  #1563729

  oradbguru (11/29/2012)

  ---

  So is it best to extract relational data in xml format and using another language like c#, apply a style sheet to transform it into the desired format?

  Exactly that!

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]

• Steven Willis

  SSCrazy Eights

  Points: 9893

  More actions

  November 30, 2012 at 2:33 pm

  #1564578

  oradbguru (11/28/2012)

  ---

  Hello, I am beginning to write a procedure that will extract data from several table in XML format and apply a style sheet. I am looking for good examples on how to do this. Any code examples with explanations would be greatly appreciated.

  Some code examples for turning query results into XML:

  http://qa.sqlservercentral.com/Forums/Topic1361033-392-3.aspx#bm1375776

  http://qa.sqlservercentral.com/Forums/Topic1344161-391-1.aspx#bm1345086