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 7:27 am

    #1540064

    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.

    _____________________________________________
    "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]