I'm creating a HL7 Continuity of Care Document (CCD) using FOR XML statements in SQL Server 2008 R2.
I've done A LOT with this method, but this is the first time I have to represent part of the data in a HTML table, which is giving me trouble.
So, I have the following information in a table:
Problem | Onset | Status --------------------------------- Ulcer | 01/01/2008 | Active Edema | 02/02/2005 | Active
and I'm trying to render the following
<tr> <th>Problem</th> <th>Onset</th> <th>Status</th> </tr> <tr> <td>Ulcer</td> <td>01/01/2008</td> <td>Active</td> </tr> <tr> <td>Edema</td> <td>02/02/2005</td> <td>Active</td> </tr>
I'm using this query:
SELECT p.ProblemType AS "td" , p.Onset AS "td" , p.DiagnosisStatus AS "td" FROM tblProblemList p WHERE p.PatientUnitNumber = @PatientUnitNumber FOR XML PATH('tr')
And I keep getting the following:
<tr> <td>Ulcer2008-01-01Active</td> </tr> <tr> <td>Edema2005-02-02Active</td> </tr>
Anyone got any advice?