Hi,
Its Simple only.... check Logical Operators (OR, AND) in Google.
I gave Sample Procedure...
CREATE PROCEDURE test
@StartDate DATETIME=NULL,
@EndDate DATETIME=NULL
AS
BEGIN
SELECT Column_List
FROM Table_Name
WHERE (Date_Field BETWEEN @StartDate AND @EndDate) OR (@StartDate IS NULL AND @EndDate IS NULL)
END
Regards,
GVPrabu