Search results for query: *

We are on PS 8.9, Oracle Database. I am trying to write a query to track department changes. The action used is not always department change. I am joining Job to Employees and selecting where employees.deptid <> job.deptid. This works fine with the exception of when multiple changes are made...

I have a formula: IF {SR_UNION_REPORT.ERNCD} in ['HUN', 'HOL', 'VAU', 'VAC', 'VPO','JUR','BON', 'LAP'] THEN 0 ELSE {SR_UNION_REPORT.OTH_HRS} The formula works fine at the employee level. When I go to get a sum of all the employees at the union level, the total includes the hours...

I have the following issue: I need to write a query using the PeopleSoft query tool (don't have access to SQLPlus) to track employees changing from regular to temp status. Need to report emplid, name and effdt of change. I need to do the same thing to track name changes. Need to report emplid...

We would like to prompt users for a year based on a date. We have created an expression substr(date,1,4) which provides us with just the year portion of the date. We would like to now prompt for the year using that expression. We are using PeopleSoft query on the web. When we attempt to do...

Has anyone switched to SQL Server 2005 yet? If so have you had any issues? Also is anyone running on 64bit hardware? Any issues?

We have a report that joins a header record with child records. The header record contains a budget field which covers all children (budget total is 150). When we subtotal it obviously gives us the budget field * the number of children (300 instead of the 150 if we have 2 children). We have...

We have a report which we total certain information by accounting period. Example; if sysdate falls in period 2, the report would have Past, Period 2, Period 3, ..., Period 11, Period 12, Future. The past column is not picking up information for the last week in January. We have had this report...

Our users use to be able to update there Internet Password by accessing their person document and editing the Internet Password. Since we have upgraded our Server to 6.5, they are no longer able to do so. Most of our clients are still at 4.5. We were going to have them edit their Internet...

We are converting a database from Oracle to SQL Server. Does anyone know what the equivalent is in SQL Server for the following Oracle syntax: 1. trunc(sysdate) In Oracle this sets the time on the date to midnight. 2. Does SQL Server have a table like the Oracle dual table? I can always add...

We have a report which we total certain information by accounting period. The report currently has columns for Past, Period 1, Period 2, ... , Period 12, Future. It only prints the current year. We would like the report to roll periods so it prints Past, Current period, Next period, ...