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

    Next to last Min Value

    I'm not sure how the field is set up. We get the file from another agency. I am using Discoverer and pulling MIN(Regular Pay) from the 'Select Items' tab. If I write a condition: MIN(Regular Pay) <> .01, I don't get any info back associated with that person. I don't know if I explained...
  2. seyfert

    Next to last Min Value

    Thanks for your suggestion Tony, but it' not working. I'm getting a datatype mismatch. I don't know if I need to change the value of the .01 and then put it in a loop to run through the line again. Or maybe use an index, but I have no idea how I could do that.
  3. seyfert

    Next to last Min Value

    Greetings, I am calculating a % change in Salary over a year. I use the Min(Regular Pay) and the Max(Regular Pay). However, If a new employee starts, .01 cents is deposited into their checking account to make sure direct deposit goes through. The Min(Regular Pay), in this case, shows up as...
  4. seyfert

    Add rows to an existing table

    Leave it to a mom to instruct on proper protocol in such a nice way. Thanks mom.
  5. seyfert

    Add rows to an existing table

    I can't believe how helpful you are. Thank you so much Mufasa. (I just love the way Whoopie Goldberg says, "Mufasa" in The Lion King) It is a lot of work if I have to update the rows that way, but it might be our only choice. This is a new procedure for our office and I'm sure the wrinkles...
  6. seyfert

    Add rows to an existing table

    I haven't heard back from anyone regarding the information in the 14 rows, but I am wondering... If I need to change the data in those rows, how would I do it? BTW-you all have been very helpful. My office was quite impressed that I(you) came up with a way to add the new data without having...
  7. seyfert

    Add rows to an existing table

    Thank you all. It seems this has created a lot of work for some other people in my office. They need to check on some things and get back with me. It is possible that those 14 rows were already part of the database.
  8. seyfert

    Add rows to an existing table

    Thank you for your reply. I tried the ignore=y and successfully got 1618 rows to be added. However 14 rows did not import. I got this error message: "IMP-00019: row rejected due to ORACLE error 1 IMP-00003: ORACLE error 1 encountered ORA-00001: unique constraint (GMU_2006.PK_FABINVH)...
  9. seyfert

    Add rows to an existing table

    Frist off - Greetings to all of you. I just found this forum, but the advice here seems awesome. I hope not to need you often, but that is never the case with me. I'm using Enterprise Manager with a schema already created for a table (gmu_2006). I want to add rows to that table using a .dmp...

Part and Inventory Search

Back
Top