SELECT        OwnerStaff_Branch, COUNT(WorkOrderID) AS MonthTotal,
                             (SELECT        COUNT(WorkOrderID) AS Expr1
                               FROM            WorkOrderReportView
                               WHERE        (dbo.DateOnly(CreatedOn) = dbo.DateOnly(GETDATE()))
                               ) AS DailyTotal
FROM            WorkOrderReportView
WHERE        (MONTH(CreatedOn) = MONTH(GETDATE())) AND (YEAR(CreatedOn) = YEAR(GETDATE()))
GROUP BY OwnerStaff_Branch

SELECT OwnerStaff_Branch, 
	COUNT(WorkOrderID) AS MonthTotal,
		(SELECT COUNT(WorkOrderID) AS Expr1
		FROM WorkOrderReportView
		WHERE (dbo.DateOnly(CreatedOn) = dbo.DateOnly(GETDATE())
			AND OwnerStaff_Branch = w.OwnerStaff_Branch)
		) AS DailyTotal
FROM WorkOrderReportView w
WHERE (MONTH(CreatedOn) = MONTH(GETDATE())) AND (YEAR(CreatedOn) = YEAR(GETDATE()))
GROUP BY OwnerStaff_Branch

DECLARE @Startmonth DATE, @Endmonth DATE, @Startday DATE, @Endday DATE
SET @Startmonth = DATEADD(MONTH,DATEDIFF(MONTH,0,GETDATE()),0)
SET @Endmonth = DATEADD(MONTH,1,@Startmonth)
SET @Startday = DATEADD(day,DATEDIFF(day,0,GETDATE()),0)
SET @Endday = DATEADD(day,1,@Startday)

SELECT @Startmonth, @Endmonth, @Startday, @Endday


SELECT OwnerStaff_Branch,
	COUNT(WorkOrderID) AS MonthTotal,
		(SELECT COUNT(WorkOrderID) AS Expr1
		FROM WorkOrderReportView
		WHERE CreatedOn >= @Startday AND CreatedOn < @Endday
			AND OwnerStaff_Branch = w.OwnerStaff_Branch)
		) AS DailyTotal
FROM WorkOrderReportView w
WHERE CreatedOn >= @Startmonth AND CreatedOn < @Endmonth
GROUP BY OwnerStaff_Branch