Try using SQL COMMAND (NOT MDX) 'CUBE', search for 'SELECT Examples' in SQL Server 2005 Help.
Try this, add also make sure that you have the required indexes: DECLARE @TeeTimeDate datetime DECLARE @TeeTimeDate_to datetime --- New variable...
Try CHECKPOINT
Separate names with a comma.