• No worries.

    Consider making your WHERE clauses SARGable:

    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

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden