Search results for query: *

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

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.

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

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

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

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

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.

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

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