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 TouchToneTommy 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: sa113
  • Content: Threads
  • Order by date
  1. sa113

    SQL Derived Fields Reference

    Would anyone happen to have a good reference that gives examples of all the SQL dervied fields functions (aggregate, string, date/time, summary...)?
  2. sa113

    Help please...trouble with a CASE statement for SQL

    For some reason this derived field is not coming up ok when testing it. What am I missing? I'm trying to get a ranged grouping going here. CASE (FLOOR(DATEDIFF (DD, PS_EMPLOYMENT.CMPNY_SENIORITY_DT, "PS_EMPLOYMENT"."TERMINATION_DT")) / 365.25) WHEN < 1 THEN 'Less then 1 year' WHEN > 1 < 2...
  3. sa113

    Recent MBA grad/Career Advice

    Hello, I am a HRIS (Human Resources Information Systems) Manager for a mid-sized bank. I have been working here for 8 years and have turned the department around with technology and outsourcing solutions. Working here has tought me a lot about managing technology however we use simpler...

Part and Inventory Search

Back
Top