select state,count(*) as Total from custdetail where active='T' and convert(varchar(20),startdate,103) between convert(varchar(20),'1/12/2005',103) and convert(varchar(20),'1/12/2013',103) group by state
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)