Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.57 KB | None | 0 0
  1. SELECT ContactType.JouNotatId AS ContactID, IDSYS.JOUKART.RegKontaktID, IDSYS.SYSUSER.SysUserID AS Signatur, CONVERT(datetime,CONVERT(varchar,IDSYS.JouHend.HendDatetm,112),0) AS HendDatetm,
  2. 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
  3. FROM IDSYS.JouSickLeave INNER JOIN
  4. IDSYS.JOUNOTAT ON IDSYS.JOUNOTAT.JouNotatID = IDSYS.JouSickLeave.JouNotat_Id INNER JOIN
  5. IDSYS.JouHend ON IDSYS.JouHend.JouHendID = IDSYS.JOUNOTAT.JouHend_Id INNER JOIN
  6. IDSYS.JOUKART ON IDSYS.JOUKART.JourID = IDSYS.JouHend.Jou_Id INNER JOIN
  7. IDSYS.SYSEVENTLINK ON IDSYS.JOUNOTAT.Local_Id = IDSYS.SYSEVENTLINK.EventLocal_Id AND IDSYS.JOUNOTAT.System_Id = IDSYS.SYSEVENTLINK.EventSystem_Id INNER JOIN
  8. IDSYS.SYSEVENT ON IDSYS.SYSEVENTLINK.SysEvent_Id = IDSYS.SYSEVENT.SysEventID INNER JOIN
  9. (
  10. SELECT IDSYS.JouNotat.JouNotatId, MIN(IDSYS.SYSEVENT.SySEventID) AS SysEventID FROM IDSYS.JouNotat INNER JOIN
  11. IDSYS.JouHend ON IDSYS.JouNotat.JouHend_Id = IDSYS.JouHend.JouHendID INNER JOIN
  12. IDSYS.SYSEVENTLINK ON IDSYS.JouNotat.Local_Id = IDSYS.SYSEVENTLINK.EventLocal_Id AND IDSYS.JouNotat.System_Id = IDSYS.SYSEVENTLINK.EventSystem_Id INNER JOIN
  13. IDSYS.SYSEVENT ON IDSYS.SYSEVENTLINK.SysEvent_Id = IDSYS.SYSEVENT.SysEventID
  14. WHERE SysEventType = 64
  15. GROUP BY IDSYS.JouNotat.JouNotatId
  16. ) AS minEvent ON IDSYS.SYSEVENT.SysEventID=minEvent.SysEventID AND IDSYS.JouNotat.JouNotatId = minEvent.JouNotatId INNER JOIN
  17. IDSYS.SYSSESSION ON IDSYS.SYSEVENT.SysSession_Id=IDSYS.SYSSESSION.SysSessionId INNER JOIN
  18. IDSYS.SYSUSER ON IDSYS.SYSSESSION.User_Id=IDSYS.SYSUSER.SysUserID LEFT OUTER JOIN
  19. (
  20. SELECT DISTINCT IDSYS.JouNotat.JouNotatId, IDSYS.InfContact.Name FROM IDSYS.InfContact INNER JOIN
  21. IDSYS.JouHend ON IDSYS.InfContact.InfContactID = IDSYS.JouHend.ConsType_InfContact_Id INNER JOIN
  22. IDSYS.JouNotat ON IDSYS.JouHend.JouHendID = IDSYS.JouNotat.JouHend_Id
  23. ) AS ContactType ON ContactType.JouNotatId = IDSYS.JouNotat.JouNotatId
  24. WHERE SysEventType = 64
  25. ORDER BY IDSYS.JOUKART.RegKontaktID, IDSYS.JouHend.HendDatetm
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement