Recent content by mwolf00

Carp, Thanks for the replies. I think I found a solution by partitioning the row number on the folderid... SELECT m. (select rr.efolderid, rr.return_reason , 'sub' src, rr.return_date FROM rbm_treturnreason rr JOIN eevent e on rr.efolderid = e.efolderid AND e.eactionname = 'Can Not Accept'...

Thank you both for the responses. Unfortunately, the events table is part of a commercially sold software program and should not be modified (it currently has about 4.5M rows). Also the returnReason table has 60k rows and while I can add a column to it, I'm not sure how to populate that...

I have a table that records all events (events). Some of those events causes data to be written to a second table (returnreason) where we have a column that counts the iteration as the event may happen more than once. Unfortunately I cannot find a way to link the particular event to the...

That is interesting. Does it work in 9i? For now I will stick with the current solution I have. Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe...

carp, What I've actually seen is that the job will run immediately when it is unbroken whether is is scheduled to run or not. Fortunately all of my jobs run either hourly or nightly. The hourly ones will run an hour after everything is enabled again and the nightly ones will run the night...

I was able to develop a solution: CREATE OR REPLACE PROCEDURE job_fixer AS CURSOR broken_jobs_cur IS SELECT job, interval FROM user_jobs WHERE broken = 'Y'; dtNext date; BEGIN FOR job_rec IN broken_jobs_cur LOOP execute immediate('select ' || job_rec.interval...

Thank you for the reply. My issue is that I cannot seem to unbreak the job with a value in the next_date field. The value is there in the USER_JOBS table in the INTERVAL field event after the jobs is broken. The problem I am having is that the value is a text field like 'SYSDATE + (1/24)' and...

I am delivering a script that will be run by a customer. At the beginning of the script, I break the jobs so that they will not start during the script execution. At the end of the script, I am fixing the jobs. The only problem that I am having is that a job that is fixed executes immediately...

I think it will take me a while to absorb the whole page, but I have been through the first few examples and I have found them well written and extremely helpful. I will have to try to work them into my queries and try to get used to using them. Thank you again. Programming today is a race...

Wow, I have no idea how this works but it works great. Thank you very much. I'm sorry for the lack of sample data but I was already simplifying this a whole lot. Here is my final solution SELECT x.txtAssignedAnalyst, f.efoldername, f.estagename FROM ( SELECT txtAssignedAnalyst...

Thank you for the reply. Example #2 is more accurate. The RequestNumber field is actually a 17 digit alpha-numeric field that really isn't sequential at all. Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe...

Hi, I am trying to write a query that will give me one random row per user. Let's say the table has a userName column and a requestNumber column. The requestNumber column is unique so that one user may have many requests. Can I write a query that will list each user once with a random request...

Hi everyone, I'm a little stuck on this one... Table eEvent tracks actions that happen to items in rbm_management. I need to find the last event that happened before billing (the billing date is returned by the function rbm_fGetBillingDate). The code works very fast when I hard code the...

I have a table which tracks events - the data looks like this. EEVENTID EFROMSTAGE ETOSTAGE EEVENTTIME 3 Request Creation Validation Check 6/26/2007 18:29 4 Validation Check Initial Review 6/26/2007 18:29 12 Initial Review Data Input 6/27/2007 15:51 21 Data...

Chopstik - server.urlEncode will actually do the opposite of what I want done. I'm trying to prevent encoding of the string which seems to be happening on its own. My script that says response.redirect "http://myserver/Metastorm/customASP/ownedIRG.pdf#page=7" makes...