提问有字数限制,所以问题另外部分如下:
CASE
WHEN (1) = '0' THEN
fncalcefficiency (
sum(
COALESCE (dcm.nAttendanceTime, 0)
),
sum(
COALESCE (dcm.NSTANDARDTIME, 0)
),
0,
0
)
ELSE
fncalcefficiency (
sum(
COALESCE (dcm.NDIRECTTIME, 0) + COALESCE (
dcm.nDirectSupportTimeQty,
0
) + COALESCE (dcm.nOTDirectTimeQty, 0) + COALESCE (
dcm.nOTDirectSupportTimeQty,
0
)
),
sum(
COALESCE (dcm.NSTANDARDTIME, 0)
),
0,
0
)
END generalRate,
CASE
WHEN (1) = '0' THEN
fncalcefficiency (
sum(
COALESCE (dcm.nAttendanceTime, 0)
),
sum(COALESCE(dcm.NCOSTTIME, 0)),
sum(
COALESCE (dcm.NNORMALSHUTDOWNTIME,