Create HTML Table with SQL FOR XML

by 
select 
  (select p.ProblemType     as 'td' for xml path(''), type),
  (select p.Onset           as 'td' for xml path(''), type),
  (select p.DiagnosisStatus as 'td' for xml path(''), type)
from tblProblemList p
where p.PatientUnitNumber = @PatientUnitNumber
for xml path('tr')

To add the header as well you can use union all.

select 
  (select 'Problem' as th for xml path(''), type),
  (select 'Onset'   as th for xml path(''), type),
  (select 'Status'  as th for xml path(''), type)
union all         
select 
  (select p.ProblemType     as 'td' for xml path(''), type),
  (select p.Onset           as 'td' for xml path(''), type),
  (select p.DiagnosisStatus as 'td' for xml path(''), type)
from tblProblemList p
where p.PatientUnitNumber = @PatientUnitNumber
for xml path('tr')

More Related Contents:

  1. Word-wrap in an HTML table
  2. Table fixed header and scrollable body
  3. How to deal with page breaks when printing a large HTML table
  4. How to avoid joining all text from Nodes when scraping
  5. How do I escape ampersands in XML so they are rendered as entities in HTML?
  6. Make a div fill the height of the remaining screen space
  7. How to remove unwanted space between rows and columns in table?
  8. How to make Scrollable Table with fixed headers using CSS [duplicate]
  9. How to make HTML table cell editable?
  10. How can I set the max-width of a table cell using percentages?
  11. Add a horizontal scrollbar to an HTML table
  12. Converting HTML to XML
  13. using text-align center in colgroup
  14. How to select first element via XPath?
  15. Valid content-type for XML, HTML and XHTML documents
  16. Is it possible to insert HTML content in XML document?
  17. Linethrough/strikethrough a whole HTML table row
  18. Frozen table header inside scrollable div
  19. Why is box-sizing acting different on table vs div?
  20. Table overflowing outside of div
  21. Border around tr element doesn’t show?
  22. How to handle xml/html in git feature branch workflow?
  23. How to completely remove borders from HTML table
  24. with fixed and scrollable [duplicate]
  25. SQL Server FOR XML Path make repeating nodes
  26. Styling the last td in a table with css
  27. Setting max-height for table cell contents
  28. How to create tables from column data instead of row data in HTML?
  29. center table in HTML
  30. How to make a table with equal column widths in CSS?

Leave a Comment