I have two tables.

1. Calendar : This table contains the date for a year.
2. VisitorTable : This table has date and Count of persons visited.

In the visitor table for few days there are no records.

The date range which has issue is 22-Aug-2014 till 30-Sep-2014.

The date are stored in below format

'2014-08-21 00:00:00.000' and '2014-10-17 00:00:00.000'

On left join of Calendar table with VisitorTable I am not getting null values for the given date range. The result is present as below

**SQL Query**

```
SELECT VisitingDate ActivityDate
,COUNT(Visit) AS Visits  
FROM CALENDAR A
  LEFT JOIN VisitorTable b
ON B.VisitingDate= A.[DATE]
  WHERE b.StoreName = 'ABC'

```

**Output**

*ActivityDate Visits*

2014-10-16 00:00:00.000 63

2014-09-30 00:00:00.000 69 

2014-08-22 00:00:00.000 51

**Calendar Table**

```
SELECT *
FROM CALENDAR A
WHERE A.[DATE] BETWEEN '2014-08-22 00:00:00.000'
        AND '2014-09-30 00:00:00.000'

```

**Output**

*DATE*

2014-08-22 00:00:00.000

2014-08-23 00:00:00.000

2014-08-24 00:00:00.000

2014-08-25 00:00:00.000

2014-08-26 00:00:00.000

2014-08-27 00:00:00.000
.

.

.

2014-09-28 00:00:00.000

2014-09-29 00:00:00.000

2014-09-30 00:00:00.000

I am plotting a grpah, thus I need dates with zero vistis.

Pointers will help.

Thanks in advance.