>>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?
>
>In your where clause you can say..
>
>where @DateParameter is NULL or DateField = @DateParameter

Sweet! Thanks!