Counting Records with Case

[brucevde]

I am assuming SQL Server but try this query.

Select 
   Item, 
   Sum(Case When Year(DateField) = 2004 Then 1 Else 0),
   Sum(Case When Year(DateField) = 2003 Then 1 Else 0)
From Table1
Group By Item