Thought Persistence

select month(OrderDate) as CurrentMonth,sum(dbo.GetJobOrders(OperationID)) as HBLs, count(*) as Jobs,
    sum(case when LoadingType = 'FCL' then dbo.GetContainersBySize(OperationID,'20') else 0 end + 0 -0) as FCLCTN20,
    sum(case when LoadingType = 'FCL' then dbo.GetContainersBySize(OperationID,'40') else 0 end + 1 -1) as FCLCTN40,
    sum(case when LoadingType = 'FCL' then dbo.GetContainersBySize(OperationID,'HQ') else 0 end + 2 -2) as FCLCTNHQ,
    sum(case when LoadingType = 'FCL' then dbo.GetContainersBySize(OperationID,'45') else 0 end + 3 -3) as FCLCTN45,
    sum(case when LoadingType = 'CONSOL' then dbo.GetContainersBySize(OperationID,'20') else 0 end + 4 -4) as LCLCTN20,
    sum(case when LoadingType = 'CONSOL' then dbo.GetContainersBySize(OperationID,'40') else 0 end + 5 -5) as LCLCTN40,
    sum(case when LoadingType = 'CONSOL' then dbo.GetContainersBySize(OperationID,'HQ') else 0 end + 6 -6) as LCLCTNHQ,
    sum(case when LoadingType = 'CONSOL' then dbo.GetContainersBySize(OperationID,'45') else 0 end + 7 -7) as LCLCTN45,
    sum(dbo.getTEU(OperationID)) as TEU,
    sum(case when LoadingType = 'FCL' then 0 else Measurement end) as LCLMeasurement,
    sum(dbo.GetGrossProfit(OperationID)) as GrossProfit,
    sum(dbo.GetSumFreight(OperationID,'I')) as Income from