Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ttrsnoob
  • Content: Threads
  • Order by date
  1. ttrsnoob

    Display Manaagers EMPLID for each employee

    I have a number of departments. In each department I have a manager. What I am looking for is a report to list each of the employees in that department with the managers ID after each employee. This is what I am trying (SELECT ("B"."EMPLID") FROM "PS_JOB" "B" WHERE (...
  2. ttrsnoob

    derived field to pull check gross in range of dates

    Is it possible to write a derived field that will pull a range of checks and give the check gross? something like... DECODE ( CHECK DATE , CHECK DATE RANGE , CHECK GROSS ) ?
  3. ttrsnoob

    Pull active employee jobcode from dept unless

    I am trying to pull a report that will show all DEPTIDs between '000100' and '009000'. I need the report to then pull the active employee's EMPLID with JOBCODE 12104 (there will only be 1 employee with that jobcode) If there are only terminated employees with jobcode 12104 I still want the...
  4. ttrsnoob

    ORA-00937: not a single-group group function

    DECODE("PS_DEPENDENT_BENEF"."DEPENDENT_BENEF",'02',( DECODE((MAX(DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' ,"PS_HEALTH_BENEFIT"."COVRG_CD" ) )),'4', (MAX( DECODE("PS_HEALTH_BENEFIT"."PLAN_TYPE",'10' , "PS_HEALTH_BENEFIT"."BENEFIT_PLAN") )) ,'5', (MAX(...
  5. ttrsnoob

    Derived Fields to pull total hours for different months

    I would like to put together a report that pulls total hours. I would need one dirived field for January and another field for February. Any ideas how I can do this? Thanks

Part and Inventory Search

Back
Top