Hi consider below script
Create table parcel (id int, name varchar(50), date int, parcel2014 int )
insert into parcel values (1,'milk',20-12-2014,0), (2,'pen',10-12-2014,0), (3,'copy',02-12-2014,0), (4,'pensil',08-10-2014,0),
(5,'pulse',07-10-2014,0)
I want data to be look like below which is count of all records of parcel2014 column in between date 08/10/2014 and 12/12/2014
I tried this
DECLARE @startdate varchar= '08/10/2014'
declare @enddate varchar= '12/12/2014'
set @enddate= '12/12/2014'
set @startdate= '08/10/2014'
select parcel2014,COUNT(*) as records from parcel where date between @startdate and @enddate
group by parcel2014
order by parcel2014
But didnt get result, pls help