>I am creating a SPROC where I am filtering by a specific date, which I am passing in as a parameter. What I would like to do is if there is a date, show records on that date, otherwise show all records. How can I implement something like this?

Using CASE Statement.