• Hi,

    Nice article.

    At one stage you say that auto mode does not allow you to specify a root element, and you provide a work around.  Are you perhaps talking about SQL 2000?  As by using the following construct with SQL 2005, you can very simply provide a root element.

    FOR XML AUTO, ROOT ('CustomersByRegion')

    Regards,

    David McKinney.