WITH cte AS (SELECT        KNUI.ID AS UserIdentificationID, KNUI.UserID AS UserIdentificationUserID, KNUI.CardID AS UserIdentificationCardID, KNUI.BiometricID, KNUI.PinID, KNUI.LastUsedDate, KNUI.TIMESTAMP,
                                                      KNUI.Active, KNUI.UserMasterId, KNUI.ActivationCode, KNUI.LicensePlateID, KNC.ID AS CardID, KNC.CardFormatID, KNC.Code, KNC.ComputedCardCode, KNC.ComputedFacilityCode,
                                                      KNU.ID AS UserID, KNU.FirstName, KNU.LastName, KNU.ActivationDate, KNU.CompanyID
                             FROM            dbo.KN_UserIdentifications AS KNUI LEFT OUTER JOIN
                                                      dbo.KN_Cards AS KNC ON KNUI.CardID = KNC.ID LEFT OUTER JOIN
                                                      dbo.KN_Users AS KNU ON KNUI.UserID = KNU.ID)
    SELECT        LGE.ID AS EventID, (DAY(LGE.TIME) + DATEPART(weekday, DATEADD(DAY, 1 - DAY(LGE.TIME), LGE.TIME)) - DATEPART(weekday, LGE.TIME)) / 7 + 1 AS [Week NUMBER], CONVERT(VARCHAR(11), LGE.TIME, 121)
                              AS DATE, RIGHT(CONVERT(VARCHAR(19), LGE.TIME, 121), 8) AS TIME, CASE WHEN RIGHT(CONVERT(VARCHAR(19), LGE.[TIME], 121), 8) BETWEEN '00:00:00' AND
                              '09:59:59' THEN 'Breakfast' WHEN RIGHT(CONVERT(VARCHAR(19), LGE.[TIME], 121), 8) BETWEEN '10:00:00' AND '15:59:59' THEN 'Lunch' WHEN RIGHT(CONVERT(VARCHAR(19), LGE.[TIME], 121), 8) BETWEEN
                              '16:00:00' AND '23:59:59' THEN 'Dineer' ELSE 'Out of Schedule' END AS MealType, LGE.Event, LGE.DoorName, LGE.UserID, LGE.UserLastName + ', ' + LGE.UserFirstName AS Names, KNC.Name AS Company,
                              cte_1.ComputedCardCode
     FROM            dbo.LG_Events AS LGE INNER JOIN
                              cte AS cte_1 ON LGE.UserID = cte_1.UserID LEFT OUTER JOIN
                              dbo.KN_Companies AS KNC ON cte_1.CompanyID = KNC.ID