Here's the required output, at the moment the rows with 0 counts are not returned:

For example If I'm running the report for the dates below, I would like to see everything in the temp table even if there's no count for it

Exec [spcAdvancedComparisonDateDWReport] @Year = '2011,2012,2013,2014', @Day = '18', @Month= 'April'

OperationalTypeAlternateKey Entry Type Date Total

9FC5554E-64C5-E311-A6AC-6C626D750814Assault / Fighting18-Apr-14 1

AFC5554E-64C5-E311-A6AC-6C626D750814Enquiry 18-Apr-14 1

68C5554E-64C5-E311-A6AC-6C626D750814Fire Alarm 18-Apr-14 0

A1C5554E-64C5-E311-A6AC-6C626D750814Inspections 18-Apr-14 3

B1C5554E-64C5-E311-A6AC-6C626D750814Theft - Snatch & Grab 18-Apr-14 1

61C5554E-64C5-E311-A6AC-6C626D750814Bank Escorts Code 13 18-Apr-14 0

A2C5554E-64C5-E311-A6AC-6C626D750814AWOL 18-Oct-13 0