Home Forums SQL Server 2008 T-SQL (SS2K8) How do I use one column for node names and the others for elements in that node? RE: How do I use one column for node names and the others for elements in that node?

  • September 20, 2012 at 10:30 am

    #1540229

    dwain.c (9/20/2012)

    Eugene Elutin (9/20/2012)

    aaron.reese (9/20/2012)

    I do have to agree with the byte-bloat issue.

    Can anyone beat this? its from the NHS clinical data set upload for patient details

    <personGenderCodeCurrent>M</personGenderCodeCurrent>

    There is nothing wrong with that!

    XML is designed specifically for this.

    For gender transformations?

    No, that is what XSLT is for.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato