您可以通过创建一个列来进行排序，从而根据需要将小计强制添加到结果中。在本示例中，我将UNION查询放入CTE中。我在两个SELECT中添加了一个名为CompanySortColumn的列。在主SELECT中，我按CompanyID、添加的CompanySortColumn、OrderID以及您想要的任何顺序对结果进行排序。

WITH prelim as (
  select distinct 
    Personid, 
    concat(rtrim(LastName),+ ', ',+ rtrim(FirstName)) as PersonName, 
    CompanyName, CompanyId, OrderId, JobTitle, 
    cast(TSPayRate as varchar) as PayRate, 
    cast(TSBillRate as varchar) as BillRate, 
    cast(RegHours as varchar) as TotalRegHours, 
    cast(OTHours as varchar) as TotalOTHours,  
    1 as CompanySortColumn  --Added column to force desired sort order with subtotals interjected at the "end" of each Company.
  from
    timesheets TSV
  where 
    CompanyId in ('000000001', '000000002') 
  --group by Personid, Concat(rtrim(LastName),+ ', ',+ rtrim(FirstName)), CompanyName, CompanyId, orderid,JobTitle, PayRate, BillRate, reghours, othours

  union all

  select distinct  
    '  ', ' ', ' ', companyid, ' ', ' ', ' ', 
    cast('SUBTOTAL' as varchar),
    sum(RegHours) as TotalRegHours, 
    sum(OTHours) as TotalOTHours ,
    2 as CompanySortColumn  --Added column to force desired sort order with subtotals interjected at the "end" of each Company.
  from
    timesheets TSV
  where 
    CompanyId in ('000000001', '000000002')     
  group by 
    companyid
)
  SELECT *
  FROM prelim
  ORDER BY CompanyID, CompanySortColumn, OrderID