• It appears that the query is working exactly as described in SQL Server Books Online.