• You would normally pass 2 date parameters to a procedure: @StartDate and @EndDate like this (using the syntax recommended above)

    CREATE PROCEDURE dbo.xxx

    (

    @StartDate DateTime,

    @EndDate DateTime

    )

    AS

    BEGIN

    SELECT * FROM MyTable

    WHERE DateField >= @StartDate AND DateField < @EndDate

    END