DECLARE @startDate date  = (SELECT cast(@month+'-01' as date))
    DECLARE @endDate date = (SELECT dateadd(month,1,@StartDate))

    INSERT INTO @Activity
    SELECT
         D.Date AS "EventDate"
        ,DATEPART(day,D.Date) AS "EventDay"
        ,(SELECT COALESCE(SUM(WorkDone),0) FROM CRTI_OnTimeWeb.dbo.WorkLog W WHERE W.ItemId = I.ItemId AND W.WorkLogDateTime between D.Date AND DATEADD(day,1,D.Date)) AS "Work"
        ,(SELECT COUNT(*) FROM CRTI_OnTimeWeb.dbo.AuditTrails A WHERE A.ItemId = I.ItemId AND A.AuditDateTime between D.Date AND DATEADD(day,1,D.Date)) AS "Audit"
        ,(SELECT COUNT(*) FROM CRTI_OnTimeWeb.dbo.EmailMessages E WHERE E.ItemId = I.ItemId AND E.SentDate between D.Date AND DATEADD(day,1,D.Date)) AS "Emails"
    FROM  CRTI_OnTimeWeb.dbo.OnTimeItems I
    CROSS JOIN (SELECT DATEADD(Day,Number,@startDate)  AS "Date" FROM master..spt_values WHERE Type='P' AND DATEADD(day,Number,@startDate) < @endDate) D
    WHERE I.ItemNumber = @tag