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

    Number rows incrementally based on previous row

    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'...
  2. mwolf00

    Number rows incrementally based on previous row

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

    Number rows incrementally based on previous row

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

    Fixing Jobs with Time

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

    Fixing Jobs with Time

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

    Fixing Jobs with Time

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

    Fixing Jobs with Time

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

    Fixing Jobs with Time

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

    Random Data Set - 1 Row Per Person

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

    Random Data Set - 1 Row Per Person

    ...> TO_DATE('1900','yyyy')) )x , ( SELECT txtAssignedAnalyst, TRUNC(dbms_random.value(1,cnt)) rnd FROM (SELECT txtAssignedAnalyst, COUNT(*) cnt FROM rbm_management WHERE TRUNC(dtActualDay2Complete) = TO_DATE('2/14/2008','mm/dd/yyyy') OR (TRUNC(dtWithdrawn) =...
  11. mwolf00

    Random Data Set - 1 Row Per Person

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

    Random Data Set - 1 Row Per Person

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

    Need help optimizing join that uses function call

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

    Outer Joins with subqueries?

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

    Equals Sign in Response Redirect

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

    Equals Sign in Response Redirect

    I am trying to redirect to a PDF file and open at a certain page. Unfortunately, the "=" sign becomes "%3D" in the address bar and does not resolve. Is there a way to prevent the encoding? response.redirect "http://myserver/Metastorm/customASP/ownedIRG.pdf#page=7" Programming today is a...
  17. mwolf00

    Compiling Recursive Functions

    ...VARCHAR2, dteff DATE) RETURN NUMBER IS intMonths PLS_INTEGER := 0; intResult PLS_INTEGER; BEGIN SELECT COUNT(*) INTO intResult FROM RBM_MANAGEMENT m, EFOLDER f, RBM_TACTION a WHERE m.efolderid = f.efolderid AND m.txtactiontype = a.action_code AND...
  18. mwolf00

    Can you replace text in an XSL?

    Here's the final solution I worked out... <xsl:template name="text.replace"> <xsl:param name="texttosearch"/> <xsl:param name="texttofind"/> <xsl:variable name="textlength" select="string-length($texttosearch)"/> <xsl:if test="$textlength &gt; 0"> <xsl:choose> <xsl:when...
  19. mwolf00

    Can you replace text in an XSL?

    Here's where I am so far - I can call the function and get the results for 'ABCZ' - but I can't figure out how to replace it with a carriage return... <TD align="center"> <xsl:attribute name="headers">idFolderName<xsl:value-of select="position()"/></xsl:attribute> <xsl:variable name="aMess"...
  20. mwolf00

    Can you replace text in an XSL?

    I'm working with a COTS product that uses an XSL page for some of its output. We are trying to add line feeds to the text that is output by <TD align="center"> <xsl:attribute name="headers">idFolderName<xsl:value-of select="position()"/></xsl:attribute> <xsl:value-of...
    • mwolf00
    • Thread
    • Replies: 3
    • Forum: XML

Part and Inventory Search

Back
Top