半個靈魂...真正的悲傷 是心的幫浦嘶嘶空轉的聲響 旁人看不出來 也聽不見

SELECT department_code 部門,employee_no 員工代號,employee_cname 員工姓名,
       EMPLOYEE_WORK_YEAR_STARTDATE 到職日,
       (DATEDIFF(DAY,EMPLOYEE_WORK_YEAR_STARTDATE,GETDATE())/365) 年, --年
       (case
       when (DATEDIFF(MONTH,EMPLOYEE_WORK_YEAR_STARTDATE,@年資計算基準日)-
                 (DATEDIFF(DAY,EMPLOYEE_WORK_YEAR_STARTDATE,@年資計算基準       日)/365)*12)=12 then 11
       else   (DATEDIFF(MONTH,EMPLOYEE_WORK_YEAR_STARTDATE,@年資計算基準日)-
                (DATEDIFF(DAY,EMPLOYEE_WORK_YEAR_STARTDATE,@年資計算基準日)/365)*12)
       end) 月,
       SUM(change_hour1) 加班時數,SUM(TOTAL_VALUE) 加班金額 from vwZZ_SURTEC_OTMEAL_CAL_DETAIL
where section_code <> 'S01'
and EMPLOYEE_WORK_STATUS <> '2'
and CONVERT(varchar(12),ASK_LEAVE_START,111) between @出勤開始時間 and @出勤結束時間
group by department_code,employee_no,employee_cname,EMPLOYEE_WORK_YEAR_STARTDATE