...
RIGHT OUTER JOIN (
                           SELECT TOP ( 100 ) PERCENT
                            ts445.Date
                           ,ts445.WorkCentre
                           ,sts1.OpCode
                           ,MAX(sts1.CostRateNT) AS CostRateNT
                           ,MAX(sts1.AssistantRate) AS AssistantRate
                           ,sts1.JobNo
                           FROM
                            Live_Costing.dbo.Timesheet AS ts445
                           INNER JOIN Live_Costing.dbo.TSTrans AS sts1 ON ts445.TimeSheetNo = sts1.TSID
                           GROUP BY
                            ts445.Date
                           ,ts445.WorkCentre
                           ,sts1.OpCode
                           ,sts1.JobNo
                           ORDER BY
                            ts445.WorkCentre
                           ,ts445.Date
                           ,sts1.OpCode
                         ) AS crsq1
        RIGHT OUTER JOIN Live_Orders.dbo.OrderHeader AS oh
...

select *
from (Select 1 as rown) a
right join (
select top(100) percent object_id,name
 from sys.objects order by name
 ) as b on a.rown<>b.object_id
 go
select *
from (Select 1 as rown) a
right join (
select top(99.99) percent object_id,name
 from sys.objects order by name
 ) as b on a.rown<>b.object_id