The Select below returns the same results as the one I first posted. Just rows with values for the filtered dates

SELECT

ot.OperationalTypeAlternateKeyAS [OperationalTypeAlternateKey]

,ot.OperationalTypeAS [Entry Type]

,Convert(Varchar, DateDayOfMonth)+' '+DateMonthName + ' '+ Convert(Varchar,DateYear) AS [Date]

,COUNT(*)AS [Total]

FROM

#tmpOperationalTypes ot

LEFT OUTER JOIN fctOperationalEntry f ON ot.OperationalTypeKey = f.OperationalTypeKey

INNER JOIN dimDate d with (nolock) ON f.ReportedDateKey = d.DateKey

INNER JOIN #tmpLocations tl ON f.LocationKey = tl.LocationKey

WHERE d.DateYear IN (SELECT Value FROM dbo.fnSplitString(@Year, ','))

AND d.DateDayOfMonth = @Day

AND d.DateMonthName = @Month

GROUP BY ot.OperationalTypeAlternateKey, ot.OperationalType, Convert(Varchar, DateDayOfMonth)+' '+DateMonthName + ' '+ Convert(Varchar,DateYear)

ORDER BY [Entry Type]