SELECT
        RootRecordId AS 'Route/@RootRecordId',
        RouteNumber,
        RouteName,
        InternetName,
        StartTime,
        EndTime,
        Direction AS 'RouteDirection/@Direction',
        StopRecordId AS 'RouteStop/@StopRecordId',
        Ord AS "Ordr"
    FROM dbo.routes
    FOR XML PATH (''), ROOT ('TMSFile');