In my procedure, the variable @year should take two forms: 1: If @Year=1, Select all years. 2: @Year= the entered year.
Here's a sample of my code:
CREATE PROC spProcName (@Year)
SELECT Year AS [YEAR], Item AS [ITEM]
WHERE Year = @YEAR
Where Year = Case when @Year = 1 Then Year else @Year end