I want to limit the number of records with date range, but this code does NOT do that.

DECLARE @ClientId [int],
        @EventStartDate DateTime,
        @EventEndDate DateTime

SET @ClientId = 1
SET @EventStartDate = '2016-05-23'
SET @EventEndDate = '2016-09-08'

SELECT 
    [CalendarEventId], [ClientId],
    [EventDate],
    [Title],
    [EventText],
    [CreatedBy], [CreatedDate],
    [ModifiedBy], [ModifiedDate],
    CASE 
       WHEN [EventDate] >= @EventStartDate
            AND EventDate <= @EventEndDate 
         THEN 'ACTIVE'
         ELSE 'NOT ACTIVE' 
    END AS [STATUS]
FROM 
    [dbo].[CalendarEvent]
WHERE 
    ClientId = @ClientId
ORDER BY 
    EventDate