| Value |
 Expression: "
-- Get add and drop log records between the begin and end dates supplied to this routine.
SELECT (CASE
WHEN StudentId.STUDENT_ID IS NOT NULL THEN StudentId.STUDENT_ID
WHEN PrevStudentLook.STUDENT_ID IS NOT NULL THEN PrevStudentLook.STUDENT_ID
ELSE '99999'
END) AS STDNT_ID
,[EFF_TRM] AS EFF_TRM
,[REF_NUM] AS REF_NUM
,dbo.udf_StringToDateTime([LOG_DATE],'') AS ActivityDate
,(CASE
WHEN LOG_ACTION = 'M' AND TRNSCTN_TY = 'D' THEN 1 -- This is a Drop Action
ELSE 0
END) as DropAction
,(CASE
WHEN LOG_ACTION = 'A' AND TRNSCTN_TY = 'A' THEN 1 -- This is an Add Action
ELSE 0
END) as AddAction
FROM [dbo].[ST_STDNT_CLS_LOG] AS ClsLog
LEFT JOIN [dbo].[ST_STDNT_A] AS StudentId
ON ClsLog.STDNT_ID = StudentId.STUDENT_ID
LEFT JOIN
( SELECT PrevStudentId.PREV_STDNT_ID
,Student1.STUDENT_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] AS PrevStudentId
JOIN ST_STDNT_A AS Student1
-- Get add and drop log records between the begin and end dates supplied to this routine.
SELECT (CASE
WHEN StudentId.STUDENT_ID IS NOT NULL THEN StudentId.STUDENT_ID
WHEN PrevStudentLook.STUDENT_ID IS NOT NULL THEN PrevStudentLook.STUDENT_ID
ELSE '99999'
END) AS STDNT_ID
,[EFF_TRM] AS EFF_TRM
,[REF_NUM] AS REF_NUM
,dbo.udf_StringToDateTime([LOG_DATE],'') AS ActivityDate
,(CASE
WHEN LOG_ACTION = 'M' AND TRNSCTN_TY = 'D' THEN 1 -- This is a Drop Action
ELSE 0
END) as DropAction
,(CASE
WHEN LOG_ACTION = 'A' AND TRNSCTN_TY = 'A' THEN 1 -- This is an Add Action
ELSE 0
END) as AddAction
FROM [dbo].[ST_STDNT_CLS_LOG] AS ClsLog
LEFT JOIN [dbo].[ST_STDNT_A] AS StudentId
ON ClsLog.STDNT_ID = StudentId.STUDENT_ID
LEFT JOIN
( SELECT PrevStudentId.PREV_STDNT_ID
,Student1.STUDENT_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] AS PrevStudentId
JOIN ST_STDNT_A AS Student1
ON Student1.ISN_ST_STDNT_A = PrevStudentId.ISN_ST_STDNT_A
) PrevStudentLook
ON ClsLog.STDNT_ID = PrevStudentLook.PREV_STDNT_ID
WHERE (([LOG_ACTION] = 'A' AND [TRNSCTN_TY] = 'A')
OR ([LOG_ACTION] = 'M' AND [TRNSCTN_TY] = 'D'))
AND [REF_NUM] IS NOT NULL
AND dbo.udf_StringToDate([LOG_DATE]) >= 'Jan 1 1900 12:00AM'
AND dbo.udf_StringToDate([LOG_DATE]) <= 'Mar 4 2016 10:33AM'
|
| Expression |
"
-- Get add and drop log records between the begin and end dates supplied to this routine.
SELECT (CASE
WHEN StudentId.STUDENT_ID IS NOT NULL THEN StudentId.STUDENT_ID
WHEN PrevStudentLook.STUDENT_ID IS NOT NULL THEN PrevStudentLook.STUDENT_ID
ELSE '99999'
END) AS STDNT_ID
,[EFF_TRM] AS EFF_TRM
,[REF_NUM] AS REF_NUM
,dbo.udf_StringToDateTime([LOG_DATE],'') AS ActivityDate
,(CASE
WHEN LOG_ACTION = 'M' AND TRNSCTN_TY = 'D' THEN 1 -- This is a Drop Action
ELSE 0
END) as DropAction
,(CASE
WHEN LOG_ACTION = 'A' AND TRNSCTN_TY = 'A' THEN 1 -- This is an Add Action
ELSE 0
END) as AddAction
FROM [dbo].[ST_STDNT_CLS_LOG] AS ClsLog
LEFT JOIN [dbo].[ST_STDNT_A] AS StudentId
ON ClsLog.STDNT_ID = StudentId.STUDENT_ID
LEFT JOIN
( SELECT PrevStudentId.PREV_STDNT_ID
,Student1.STUDENT_ID
FROM [dbo].[ST_STDNT_A_PREV_STDNT_ID_USED] AS PrevStudentId
JOIN ST_STDNT_A AS Student1
|
Properties
