Mute Duck

Linking a parameter (in an SSRS report)

DECLARE @parameter VARCHAR(60)
SET @parameter = ''

SELECT
   *
FROM 
WHERE
   ...
AND ((@parameter = '<ALL>') OR ([table_name].column_name = @parameter))