SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='7810225805261') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='7810225805261') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-GTSGOLD')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='7810225805261') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-AVOID')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='7810225805261') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-COVID19')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-GTSGOLD')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-AVOID')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-COVID19')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-GTSGOLD')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-AVOID')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='6811105189082') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-COVID19')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='9502175491089') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='9502175491089') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-GTSGOLD')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='9502175491089') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-AVOID')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106) FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='9502175491089') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-COVID19')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC
SELECT TOP(1) S.Code as [Course],DATEDIFF(day, GETDATE(), I.dDueBy) as [Days], CONVERT(varchar(20), I.dDueBy, 106),S.Description_1 FROM       _rtblIncidents I INNER JOIN _rtblPeople P ON I.iPersonID = P.idPeople INNER JOIN StkItem S ON I.iStockID = S.StockLink  LEFT JOIN _rtblIncidentType T ON I.iIncidentTypeID = T.idIncidentType WHERE     (I.dCreated >= dateadd(year,-S.uiIIYearsCourseValidFor,getdate()))  AND       (dateadd(year,S.uiIIYearsCourseValidFor,I.dCreated) >= dateadd(day,-60,getdate())) AND       ( P.ucPPLIDNumber ='') AND       (T.cDescription = 'Course Attendance')  AND       (I.ucINCCompetent = 'Competent')  AND	   (S.Code IN('ZA-AH-SSIND-SMTR','ZA-AH-SSIND-RBMR','ZA-AH-SSIND-PMR')) ORDER BY I.dCreated DESC, I.idIncidents DESC