SQL Where clause conditional assignment based on another parameter

Question

I need to generate a report where the user can choose All Issues, Open Issues, or Closed issues in a radio button. In my view I have a isClosed bit column. If I didn't have the All Issues radio box I'd just do:

SELECT *
FROM MyView
WHERE isClosed = @ViewClosedRecords

However I need to remove the isClosed = @ViewClosedRecords condition when the @ViewAllRecords = true. How would I do this?

Answer 1

SELECT *
FROM MyView
WHERE @ViewAllRecords OR isClosed = @ViewClosedRecords

Kindness,

Dan

Answer 2

select *
from MyView
WHERE isClosed = @ViewClosedRecords
OR @ViewAllRecords

And set @ViewAllRecords parameters to true when user selects "All Issues" in the radio button.

Answer 3

WHERE
(@ViewAllRecords = false AND isClosed = @ViewClosedRecords)
OR 
(@ViewAllRecords = true)

Answer 4

The following will give you all rows with isClosed = @ViewClosedRecords. If @ViewAllRecords = true then it will return all rows and ignore isClosed.

SELECT *
FROM MyView
WHERE isClosed = @ViewClosedRecords
   OR @ViewAllRecords = true

Answer 5

WHERE (@ViewAllRecords <> true AND isClosed = @ViewClosedRecords)