select count(*) from Table_cleanse WHERE reject_date
BETWEEN cast('10/01/2012'  as datetime)
AND cast('10/31/2012' as datetime)

SELECT reject_date,COUNT(*) AS DailyRejects
FROM   Table_cleanse
WHERE  reject_date
       BETWEEN CAST('10/01/2012' AS DATETIME)
       AND CAST('10/31/2012' AS DATETIME)
GROUP BY reject_date
ORDER BY reject_date;

SELECT 
	DATEADD(dd,DATEDIFF(dd,0,reject_date),0) AS reject_date,
	COUNT(*) AS DailyRejects
FROM   Table_cleanse
WHERE  reject_date
       BETWEEN CAST('10/01/2012' AS DATETIME)
       AND CAST('10/31/2012' AS DATETIME)
GROUP BY DATEADD(dd,DATEDIFF(dd,0,reject_date),0)
ORDER BY DATEADD(dd,DATEDIFF(dd,0,reject_date),0);

CREATE TABLE #Table_cleanse(reject_date DATETIME, number_of_rejects INT);
INSERT INTO #Table_cleanse VALUES
('20121001',11),
('20121001',17),
('20121002',9),
('20121003',2),
('20121003',5);

--- 1
SELECT
	reject_date,
	COUNT(*) AS DailyRejects
FROM
	#Table_cleanse
GROUP BY 
	reject_date
ORDER BY
	reject_date;

-- 2
SELECT
	reject_date,
	SUM(number_of_rejects) AS DailyRejects
FROM
	#Table_cleanse
GROUP BY 
	reject_date
ORDER BY
	reject_date;
	
DROP TABLE #Table_cleanse;