Search results for query: *

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

Thanks for the reply. I finally did this following formula and it worked: CASE WHEN (FLOOR(DATEDIFF (DD, PS_EMPLOYMENT.CMPNY_SENIORITY_DT, "PS_EMPLOYMENT"."TERMINATION_DT")) / 365.25) < 1.00 THEN '< 1 year' WHEN (FLOOR(DATEDIFF (DD, PS_EMPLOYMENT.CMPNY_SENIORITY_DT...

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...

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...

You also may want to check out the key fields. You may have too many fields set up as key fields.

Thanks for the tip however do you know how I would have all three in their own colmns? I would like one row and 3 columns with each code instead of 3 rows per employee. Thanks

Need to know how to do the same thing...I know you have to assign an alias and however what if the tables I am using both have multiple rows and need an outer join as well? Example, I would like to create a report that lists the review ratings for each employee in each year on one row.