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 Chriss Miller 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: *

  1. notadba

    Peoplesoft: Query Manager - Max(EFFSEQ);

    Hi Kkecia, I assume that your question means you after the max date and sequence for a date within a date range. If you use the default effdt/effseq sub queries, then the query will not work for you as that only allows for a single date for the max. You need to create your own sub queries in...
  2. notadba

    Query not returning desired results when calculating monthly sum of salaries paid

    Hi egstatus, You are doing nothing wrong - you have the core of the sql correct. There is probably a far more elegant way to do this, but you could try something like this (totally untested) SELECT X.CORR_EMPRESA , X.NOMBRE_EMPRESA , MAX(X.ENE) AS ENE , MAX(X.FEB) AS FEB , MAX(X.MAR) AS MAR ...
  3. notadba

    datetime field

    Just an update - Change your datatype to a DT_STR length 10 ISNULL(BLOOM_ISSUE_DT) ? "1900-01-01" : (DT_STR,10,1250)(BLOOM_ISSUE_DT) This will set null dates to your 1900 date, the string convert looks at first 10 characters and uses the ANSI code page 1250 for character set decode - but...
  4. notadba

    datetime field

    Hi, The issue is that you are trying to trim and change case on a date time field. You need to cast/convert the date time to a char field before you can change the format. I am not sure what you were trying to achieve with making a date in uppercase? If you are looking at trimming the...
  5. notadba

    truncation error

    What is the field length of the destination column? Sounds like you have exceed that limit with the concatenated values in your derived column. You will need whatever length the BLOOM_COUNTRY column was + the appended length of BLOOMBERG. To see the error, set the redirect on for truncation...
  6. notadba

    another expression im stuck with

    Hi, Assume this one is also using the derived column stage. There is a pick list of the expressions when you build the derived column which should serve as a start point - but they are sometimes a little confusing. Your example does not provide an opt out clause where RTG_SP and RTG_MOODY do...
  7. notadba

    expression

    Without seeing your data types, the derived expression will be something like: ISS_COUNTRY =="" ? "BLOOMBERG" + BLOOM_COUNTRY : ISS_COUNTRY Just depends on your database and how you handle blank or nulls against the ISS_COUNTRY column May need to be ISNULL( ISS_COUNTRY) ? "BLOOMBERG" +...
  8. notadba

    Laptop boot issue

    Thanks for the feedback so far. Looks like it is a BIOS issue. Seems to be trying to default to a vga driver on start. Only problem is that I can rarely get it to start consistently to get in and change it. Also without ever achieving 2 successful boots in a row, I am not keen to try flashing...
  9. notadba

    Laptop boot issue

    Hi, Any help would be appreciated. I have a netbook (Toshiba NB305 Windows 7). It stopped booting a few weeks back. On startup, machine powers, HDD starts reading then nothing - however fan still runs, keys light up etc. I tried the usual restarts, battery out, reset RAM etc. No avail. On...
  10. notadba

    MS SQL Data Transmission Bandwidth

    I think your question may be too broad. Data bandwidth is more than likely related to network traffic rather than anything on the database. You can probably provide some data based on the client statistics based on some of the sql being passed. You will need to identify some common or long...
  11. notadba

    PS 9.1 - Query tool issue (Outer join w/ Effdate)

    Hi, In your not exists subquery, you should not be slecting any columns. Remove the selected field (B.EMPLID ) and instead create a join criteria on the B.EMPLID = A.EMPLID in the subquery. That should work.
  12. notadba

    PS 9.1 - Query tool issue (Outer join w/ Effdate)

    Hi Nancy, One of the joys of PSQuery. Outer joins do not work well when you need max effdt/effseq subqueries on the outer join table. Probably the simplest way to do this is leave the current query in place (or convert it to an inner join) and add a union and return the rows from the...
  13. notadba

    date calculation - 12th of last month

    You could go 'slightly' easier with: SELECT CURRENT DATE - 1 MONTH - DAY(CURRENT DATE)DAYS + 12 DAYS FROM SYSIBM.SYSDUMMY1 Which at least keeps everything as a date through the calculation.... but gets you the same result.
  14. notadba

    Using JOB record in an QUERY MANAGER outer join. Need help.

    You can delete the max effdt/sequence criteria as it serves no purpose against this table/materialised view.
  15. notadba

    Using JOB record in an QUERY MANAGER outer join. Need help.

    Hi commish252, Do you need to use JOB? Are you running the employees refresh process - if so PS_EMPLOYEES will have the current snapshot for all active employees removing the need for the effective date logic.
  16. notadba

    Need to Begin_Date and End_Date columns to an EFFDT table.

    What are you trying to do this in - a report, query, building a new table? Is it a one-off?
  17. notadba

    Transformer TR0190 arithmetic overflow error - URGENT

    Hi Sid, Divide by zero can be handled in the cube - and you can choose the default display of them. In analysis studio Use "Settings", "Data Format" and this will allow you to change the display of most error types. Hope that helps.
  18. notadba

    Department Changes

    Hi tcimis, You are absolutely right with the 2 Job "C" tables. I only have a version 7 PeopleSoft running on DB2 using Australian date format - so writing the code freehand in notepad without testing. Sorry about that. I see you did not go with the lazy DEPT_ENTRY_DATE option ;-) OK...
  19. notadba

    Department Changes

    I see my deliberate mistake ;-) I wrote this from job perspective - whereas employees already resolves the current deptid. Modified code below. What I am guessing is happening is that you have not converted the date format to 'YYYY-MM-DD'. SO what is happening is that it is finding the max...
  20. notadba

    Department Changes

    Hi TCMIS, This kind of thing can be done - but you need to get into writing expressions. If you take the default max effdt and seqeunce logic, then this will basically screw up. What you can do is compare the date and sequence together by creating your own subquery on job. Basic syntax would...

Part and Inventory Search

Back
Top