>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
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________
