• Just a note - FOR XML EXPLICIT is deprecated in Katmai and will be removed in a future version of SQL Server.