you should be able to do the following in the WHERE Clause

WHERE (FromDate >= ISNULL(@BegDate, FromDate)),

AND (ToDate <=ISNULL(@EndDate, ToDate)),

AND (name = ISNULL(@paramname,...