SELECT(
    SELECT[t10].[DateOfBirth]
    FROM (
        SELECT TOP (1) [t9].[DateOfBirth]
FROM[RotaShift] AS[t6]
        INNER JOIN[RotaEmployee] AS[t7] ON[t7].[Id] = [t6].[RotaEmployeeId]
INNER JOIN[Employee] AS[t8] ON[t8].[Id] = [t7].[EmployeeId]
LEFT OUTER JOIN[Person] AS[t9] ON[t9].[Id] = [t8].[PersonId]
WHERE([t5].[EmployeeId] = [t7].[EmployeeId]) AND([t6].[PayType] = 0) AND([t6].[Date] >= @p1) AND([t6].[Date] <= @p2) AND([t8].[Status] = 'Current') AND([t7].[EmployeeId] <> '6d54e20a-6178-4fed-8068-f1a8f28fb0f2')
        ) AS[t10]
    ) AS[DateOfBirth], (
   SELECT[t15].[StartDate]
FROM(
      SELECT TOP (1) [t13].[StartDate]
FROM[RotaShift] AS[t11]
        INNER JOIN[RotaEmployee] AS[t12] ON[t12].[Id] = [t11].[RotaEmployeeId]
INNER JOIN[Employee] AS[t13] ON[t13].[Id] = [t12].[EmployeeId]
LEFT OUTER JOIN[Person] AS[t14] ON[t14].[Id] = [t13].[PersonId]
WHERE([t5].[EmployeeId] = [t12].[EmployeeId]) AND([t11].[PayType] = 0) AND([t11].[Date] >= @p1) AND([t11].[Date] <= @p2) AND([t13].[Status] = 'Current') AND([t12].[EmployeeId] <> '6d54e20a-6178-4fed-8068-f1a8f28fb0f2')
        ) AS[t15]
    ) AS[StartDate], (
   SELECT[t20].[EmployeeNumber]
FROM(
      SELECT TOP (1) [t18].[EmployeeNumber]
FROM[RotaShift] AS[t16]
        INNER JOIN[RotaEmployee] AS[t17] ON[t17].[Id] = [t16].[RotaEmployeeId]
INNER JOIN[Employee] AS[t18] ON[t18].[Id] = [t17].[EmployeeId]
LEFT OUTER JOIN[Person] AS[t19] ON[t19].[Id] = [t18].[PersonId]
WHERE([t5].[EmployeeId] = [t17].[EmployeeId]) AND([t16].[PayType] = 0) AND([t16].[Date] >= @p1) AND([t16].[Date] <= @p2) AND([t18].[Status] = 'Current') AND([t17].[EmployeeId] <> '6d54e20a-6178-4fed-8068-f1a8f28fb0f2')
        ) AS[t20]
    ) AS[EmployeeNumer], (
   SELECT[t25].[EmployeeId]
FROM(
      SELECT TOP (1) [t22].[EmployeeId]
FROM[RotaShift] AS[t21]
        INNER JOIN[RotaEmployee] AS[t22] ON[t22].[Id] = [t21].[RotaEmployeeId]
INNER JOIN[Employee] AS[t23] ON[t23].[Id] = [t22].[EmployeeId]
LEFT OUTER JOIN[Person] AS[t24] ON[t24].[Id] = [t23].[PersonId]
WHERE([t5].[EmployeeId] = [t22].[EmployeeId]) AND([t21].[PayType] = 0) AND([t21].[Date] >= @p1) AND([t21].[Date] <= @p2) AND([t23].[Status] = 'Current') AND([t22].[EmployeeId] <> '6d54e20a-6178-4fed-8068-f1a8f28fb0f2')
        ) AS[t25]
    ) AS[EmployeeId], [t5].[value] AS[ActualTotalTime], [t5].[value2] AS[PayValue], [t5].[value3] AS[HolidayPay], [t5].[value4]
AS[HolidayAbsenceHours]
FROM(
SELECT SUM([t4].[ActualTotalTime]) AS[value], SUM([t4].[value]) AS[value2], SUM([t4].[AbsenceHours] *[t4].[PayValue]) AS[value3], SUM([t4].[AbsenceHours]) AS[value4], [t4].[EmployeeId]
FROM(
SELECT ([t0].[ActualTotalTime]) *[t0].[PayValue] AS[value], [t0].[PayType], [t0].[Date], [t2].[Status], [t1].[EmployeeId], [t0].[ActualTotalTime], [t0].[AbsenceHours], [t0].[PayValue]
FROM[RotaShift] AS[t0]
        INNER JOIN[RotaEmployee] AS[t1] ON[t1].[Id] = [t0].[RotaEmployeeId]
INNER JOIN[Employee] AS[t2] ON[t2].[Id] = [t1].[EmployeeId]
LEFT OUTER JOIN[Person] AS[t3] ON[t3].[Id] = [t2].[PersonId]
        ) AS[t4]
    WHERE([t4].[PayType] = 0) AND([t4].[Date] >= @p1) AND([t4].[Date] <= @p2) AND([t4].[Status] = 'Current') AND([t4].[EmployeeId] <> '6d54e20a-6178-4fed-8068-f1a8f28fb0f2')
    GROUP BY[t4].[EmployeeId]
    ) AS[t5]