| Value |
 Expression: "IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendWeek.POSITION_CODE))
+
REPLICATE('0', 3 - LEN(AttendWeek.ASSIGNMENT_INTERNAL_SEQ)) + CAST(AttendWeek.ASSIGNMENT_INTERNAL_SEQ AS VARCHAR(3))
AS VARCHAR(20)) AS AssignmentAK
,StartDate.SundayDate AS StartDateSK
,EndDate.SaturdayDate AS EndDa
IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendWeek.POSITION_CODE))
+
REPLICATE('0', 3 - LEN(AttendWeek.ASSIGNMENT_INTERNAL_SEQ)) + CAST(AttendWeek.ASSIGNMENT_INTERNAL_SEQ AS VARCHAR(3))
AS VARCHAR(20)) AS AssignmentAK
,StartDate.SundayDate AS StartDateSK
,EndDate.SaturdayDate AS EndDateSK
,CAST('NORM' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the Normal hours over the number of days in the Reporting Period
,CAST(ROUND(ISNULL(AttendWeek.TOTAL_NORMAL_HOURS, 0) / (DATEDIFF(DD, CAST(AttendWeek.ATTENDANCE_START_DATE AS DATE), CAST(AttendWeek.ATTENDANCE_END_DATE AS DATE)) + 1),4) AS NUMERIC(9,4)) AS HoursWorked
FROM ATTENDANCE_AND_DAY_A AttendWeek
-- Create one record for each day in the Reporting Period
LEFT OUTER JOIN [EnterpriseDW ].[dbo].[DimDate] Daily
ON
(
Daily.DateSK >= AttendWeek.ATTENDANCE_START_DATE
AND Daily.DateSK <= AttendWeek.ATTENDANCE_END_DATE
)
-- Get the Sunday before each day in the Period
OUTER APPLY
(
SELECT MAX(DateSK) AS SundayDate
FROM [EnterpriseDW].[dbo].[DimDate] GetSun
WHERE GetSun.DayOfWeek = 1
AND GetSun.DateSK <= Daily.DateSK
) StartDate
-- Get the Saturday after each day in the Period
OUTER APPLY
(
SELECT MIN(DateSK) AS SaturdayDate
FROM [EnterpriseDW].[dbo].[DimDate] GetSat
WHERE GetSat.DayOfWeek = 7
AND GetSat.DateSK >= Daily.DateSK
) EndDate
WHERE AttendWeek.ATTENDANCE_INTERNAL_ID IS NOT NULL
AND AttendWeek.TOTAL_NORMAL_HOURS IS NOT NULL
AND AttendWeek.UNPROCESSED_IND = 0
|
| Expression |
"IF 2=3
BEGIN
SELECT
CAST(0 AS INT) AS EmployeeAK
,CAST('aaa' AS VARCHAR(8)) AS PositionAK
,CAST('aaa' AS VARCHAR(20)) AS AssignmentAK
,CAST(0 AS INT) AS StartDateSK
,CAST(0 AS INT) AS EndDateSK
,CAST('aaa' AS VARCHAR(4)) AS TimeTypeAK
-- Calculate the average for the OverTime hours over the number of days in the Reporting Period
,CAST(0 AS NUMERIC(9,4)) AS HoursWorked
END
SELECT
AttendWeek.PERSON_ID AS EmployeeAK
,POSITION_CODE AS PositionAK
,CAST(
REPLICATE('0', 9 - LEN(AttendWeek.PERSON_ID)) + CAST(AttendWeek.PERSON_ID AS VARCHAR(9))
+
CAST(AttendWeek.POSITION_CODE AS VARCHAR(8)) + REPLICATE(' ', 8 - LEN(AttendWeek.POSITION_CODE))
+
REPLICATE('0', 3 - LEN(AttendWeek.ASSIGNMENT_INTERNAL_SEQ)) + CAST(AttendWeek.ASSIGNMENT_INTERNAL_SEQ AS VARCHAR(3))
AS VARCHAR(20)) AS AssignmentAK
,StartDate.SundayDate AS StartDateSK
,EndDate.SaturdayDate AS EndDa |
Properties
