Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.
case statement SELECT ORGWON, CASE CLOSEDFLAG WHEN 'Y' THEN 'CLOSED' WHEN 'N' THEN 'OPEN' ELSE 'NA' END AS WO_STATUS FROM WORKORDER select statement SELECT T.ORGWON,NVL(B.TOTAL_PARTS,0)AS "TOTAL_PARTS",T.TOTAL_HOURS,(NVL(B.TOTAL_PARTS,0)+T.TOTAL_HOURS) AS "TOTAL_ALL" FROM ( SELECT ORGWON, ROUND((TOTAL_HR)*(AVGCONTRATE),2) AS "TOTAL_HOURS" FROM ( select ORGWON,ROUND(SUM(reghours),2)AS "TOTAL_HR" from logmaint.taskperson where laborcde='01' and employeetype='K' GROUP BY ORGWON ) , LOGMAINT.unitparameter ) T LEFT OUTER JOIN ( SELECT ORGWON,SUM(PARTS_TOTAL)AS "TOTAL_PARTS" FROM ( SELECT TASKPERSON.ORGWON, QTYISSUE, ROUND((QTYISSUE)*(PRICE/MEASQ),2)AS "PARTS_TOTAL" FROM LOGMAINT.WRKORDPART,LOGMAINT.CATALOG,LOGMAINT.TASKPERSON WHERE CATALOG.NIINPNO=WRKORDPART.niinpno AND TASKPERSON.ORGWON=WRKORDPART.ORGWON AND QTYISSUE > '0' and PARTINSTALLED='Y' GROUP BY TASKPERSON.ORGWON,QTYISSUE,PRICE,MEASQ) GROUP BY ORGWON ) B ON B.ORGWON= T.ORGWON
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.