- 博客(4)
- 收藏
- 关注
原创 Kronos获取自定义信息
SELECT VPAP.PERSONNUM ,PCD.PERSONCSTMDATATXT FROM VP_ALLPERSONV42 VPAP LEFT JOIN PERSONCSTMDATA PCD ON (VPAP.PERSONID= PCD.PERSONID AND PCD.CUSTOMDATADEFID= (select CUSTOMDATADEFID from CUSTOMDA
2015-05-30 17:27:24 493
原创 将秒数显示为小时分钟数
select PAYCODENAME ,APPLYDATE ,TIMEINSECONDS ,RIGHT('00'+ CAST(TIMEINSECONDS/3600 AS VARCHAR), 2) +':'+RIGHT('00'+ CAST(TIMEINSECONDS%3600/60 AS VARCHAR), 2) CLOCK from VP_TOTALS where PERSONNUM =
2015-05-20 11:48:18 586
原创 Kronos获取累计池数量
SELECT SUM(ACCRUALTRAN.AMOUNT) FROM ACCRUALTRAN WHERE ( ACCRUALTRAN.ACCRUALCODEID=@accrualcodeid AND ACCRUALTRAN.EFFECTIVEDATE <=@enddate AND (ACCRUALTRAN.EFFECTIVEDATE>= (SELECT MAX
2015-05-20 11:30:05 500
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人