Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ContactType.JouNotatId AS ContactID, IDSYS.JOUKART.RegKontaktID, IDSYS.SYSUSER.SysUserID AS Signatur, CONVERT(datetime,CONVERT(varchar,IDSYS.JouHend.HendDatetm,112),0) AS HendDatetm,
- CONVERT(datetime,CONVERT(varchar,IDSYS.JouSickLeave.FromDate,112),0) AS FromDate, CONVERT(datetime,CONVERT(varchar,IDSYS.JouSickLeave.ToDate,112),0) AS ToDate, IDSYS.JouSickLeave.Diagnosis, IDSYS.JouSickLeave.PeriodStartDate, IDSYS.JouSickLeave.type
- FROM IDSYS.JouSickLeave INNER JOIN
- IDSYS.JOUNOTAT ON IDSYS.JOUNOTAT.JouNotatID = IDSYS.JouSickLeave.JouNotat_Id INNER JOIN
- IDSYS.JouHend ON IDSYS.JouHend.JouHendID = IDSYS.JOUNOTAT.JouHend_Id INNER JOIN
- IDSYS.JOUKART ON IDSYS.JOUKART.JourID = IDSYS.JouHend.Jou_Id INNER JOIN
- IDSYS.SYSEVENTLINK ON IDSYS.JOUNOTAT.Local_Id = IDSYS.SYSEVENTLINK.EventLocal_Id AND IDSYS.JOUNOTAT.System_Id = IDSYS.SYSEVENTLINK.EventSystem_Id INNER JOIN
- IDSYS.SYSEVENT ON IDSYS.SYSEVENTLINK.SysEvent_Id = IDSYS.SYSEVENT.SysEventID INNER JOIN
- (
- SELECT IDSYS.JouNotat.JouNotatId, MIN(IDSYS.SYSEVENT.SySEventID) AS SysEventID FROM IDSYS.JouNotat INNER JOIN
- IDSYS.JouHend ON IDSYS.JouNotat.JouHend_Id = IDSYS.JouHend.JouHendID INNER JOIN
- IDSYS.SYSEVENTLINK ON IDSYS.JouNotat.Local_Id = IDSYS.SYSEVENTLINK.EventLocal_Id AND IDSYS.JouNotat.System_Id = IDSYS.SYSEVENTLINK.EventSystem_Id INNER JOIN
- IDSYS.SYSEVENT ON IDSYS.SYSEVENTLINK.SysEvent_Id = IDSYS.SYSEVENT.SysEventID
- WHERE SysEventType = 64
- GROUP BY IDSYS.JouNotat.JouNotatId
- ) AS minEvent ON IDSYS.SYSEVENT.SysEventID=minEvent.SysEventID AND IDSYS.JouNotat.JouNotatId = minEvent.JouNotatId INNER JOIN
- IDSYS.SYSSESSION ON IDSYS.SYSEVENT.SysSession_Id=IDSYS.SYSSESSION.SysSessionId INNER JOIN
- IDSYS.SYSUSER ON IDSYS.SYSSESSION.User_Id=IDSYS.SYSUSER.SysUserID LEFT OUTER JOIN
- (
- SELECT DISTINCT IDSYS.JouNotat.JouNotatId, IDSYS.InfContact.Name FROM IDSYS.InfContact INNER JOIN
- IDSYS.JouHend ON IDSYS.InfContact.InfContactID = IDSYS.JouHend.ConsType_InfContact_Id INNER JOIN
- IDSYS.JouNotat ON IDSYS.JouHend.JouHendID = IDSYS.JouNotat.JouHend_Id
- ) AS ContactType ON ContactType.JouNotatId = IDSYS.JouNotat.JouNotatId
- WHERE SysEventType = 64
- ORDER BY IDSYS.JOUKART.RegKontaktID, IDSYS.JouHend.HendDatetm
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement