Offerid date offeravaliable Emailid 73 6/8/2014 00:00:00 True 2 74 6/9/2014 00:00:00 True 2 75 6/10/2014 00:00:00 True 2 76 6/11/2014 00:00:00 True 2 77 6/12/2014 00:00:00 True 2 78 6/13/2014 00:00:00 True 2 79 6/14/2014 00:00:00 True 2 80 6/16/2014 00:00:00 True 2 81 6/17/2014 00:00:00 True 4 82 6/18/2014 00:00:00 True 4 83 6/19/2014 00:00:00 True 4 84 6/20/2014 00:00:00 True 4 89 6/27/2014 00:00:00 True 4 90 6/28/2014 00:00:00 True 4 91 6/29/2014 00:00:00 True 4 92 6/30/2014 00:00:00 True 4 93 6/1/2014 00:00:00 True 4 94 6/2/2014 00:00:00 True 4 95 6/3/2014 00:00:00 True 2 96 6/4/2014 00:00:00 True 2 97 6/5/2014 00:00:00 True 2 98 6/6/2014 00:00:00 True 2 99 6/7/2014 00:00:00 True 2 100 6/21/2014 00:00:00 True 4 101 6/22/2014 00:00:00 True 4 102 6/23/2014 00:00:00 True 4 103 6/24/2014 00:00:00 True 4 104 7/1/2014 00:00:00 True 4 105 7/2/2014 00:00:00 True 4 106 7/3/2014 00:00:00 True 4 121 7/6/2014 00:00:00 True 2 122 7/7/2014 00:00:00 True 2 123 7/8/2014 00:00:00 True 2
StartDate - EndDate EmailID 6/1/2014 - 6/2/2014 4 6/3/2014 - 6/14/2014 2 6/16/2014 - 6/16/2014 2 6/17/2014 - 6/24/2014 4 6/27/2014 - 6/30/2014 4 7/1/2014 - 7/3/2014 4
SELECT date,count(*) WHERE date between @start and @end GROUP BY date
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)