Here is a sample of what I have in my table (SQL Server):

```
Start       End
2014-08-31  2014-09-01 
2014-09-09  2014-09-11 
2014-09-11  2014-09-26 
2014-09-15  2014-09-23 
2014-09-16  2014-09-22 
2014-09-17  2014-09-19 
2014-09-17  2014-09-26 
2014-09-17  2014-10-03 
2014-09-17  2014-09-26 
2014-09-17  2014-09-18 
2014-09-18  2014-10-04 
2014-09-18  2014-09-19 
2014-09-18  2014-09-19 
2014-09-19  2014-09-20 

```

This is a Leave request table. I need to get the total count per days.
The output should be like this.

```
2014-08-31 == 1
2014-09-01 == 1
2014-09-09 == 1
2014-09-10 == 1
2014-09-11 == 2
2014-09-12 == 1
2014-09-13 == 1
2014-09-14 == 1
2014-09-15 == 2
2014-09-16 == 2
2014-09-17 == 8
2014-09-18 == 11
2014-09-19 == 11
2014-09-20 == 8

```