SQL case when expression using excel date parameter

1

Hi ,

I want to get data from table like sql statement but i ma using sum(case when expression and in this i have to provide a criteria

sum(case when xx="fff" and date= "parameter from excel")

how can i do that

2

can you provide sample data? like the following

create table #alfa(xx varchar(50), harvestdate date)

insert into #alfa
select 'rice', getdate() union
select 'wheat', getdate() union
select 'fff', getdate() union