Home Forums SQL Server 2012 SQL Server 2012 - T-SQL XML Level/Aliasing Help RE: XML Level/Aliasing Help

  • September 30, 2013 at 1:31 pm

    #1654700

    Hi Alan,

    Thanks, that sort of gets things right. However I still have three columns with concatenated data that should be separated out:

    SURVEY_CNTCTS

    182142MWilsonm@wilson.com1-514-5623456182142442Senior Management

    183144Jean-LucPicardjean-luc@ncc-1701d.fr183144444Senior Management

    184146ZMenziesZ.Menzies@thenotebook.com1-601-56589342184146446Facility Hazards Contact184146447Senior Management

    185147JimmyKatzjkatz@sandwiches.com1-567-33567788x486185147448Facility Hazards Contact185147449Senior Management

    VISIT_SURVEY

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    SURVEY_EXTRACT

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    182Visit10692810016800002MMM2013-08-13RegularFacility HazardsEnglish (United States)23423 Address StRedmondWashington98053USA024

    Any ideas why? Is it because the column names repeat?

    Thanks!