Home Forums Programming General splitting table data into columns and xml in another table RE: splitting table data into columns and xml in another table

  • October 3, 2012 at 5:16 am

    #1544812

    SELECT UniqueID,ID,Name,

    (SELECT Latitude,

    Longitude

    FOR XML PATH('Metadata'),TYPE) AS Metadata

    FROM tab1;

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537