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 Rhinorhino 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: *

  • Users: mwolf00
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. mwolf00

    Compiling Recursive Functions

    Is there any way to compile a recursive function without it "failing" the first time? It does seem to actually complile, but shows an error in the output. If you compile it a second time, it works without error messages. CREATE OR REPLACE FUNCTION Rbm_Fgetholdoverlength( txtlease...
  8. 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
  9. mwolf00

    Help with outer join

    Hi, I'm having a little problem with and outer join (and I can't get TGML to work either). It's the one that I tried to highlight below. SELECT trim(foc.code_name), trim(bc.code_name), TRIM(pt.code_name) , trim(pu.code_name) , SUBSTR(a.st_fcly_cde,3,2) AS st_fcly_cde ...
  10. mwolf00

    Can you create a timeline without dates?

    I am trying to do a timeline based on number of days only. So if there is a date in the future, I want to show - 45 days for a task, 30 days for another and show the cumulative day counts (regardless of date). I don't want to display any dates at all. Is this possible? Programming today is a...
  11. mwolf00

    Update table based on other query

    Sorry if this seems basic but I'm having a brain cramp this morning. I want to update a table with data from another table but I really don't need to join the two. My query from the second table returns just one row. So it looks something like this UPDATE myTable SET col1 = subquery.colA...
  12. mwolf00

    Basic function question

    It's been about 5 years since I trained on Oracle and I haven't used it since (I've been using SQL Server). I'm trying to write a basic function that will take a date and make sure that it happens between 7AM and 5PM M-F excluding holidays. I know that I could do it in a SQL Server procedure...
  13. mwolf00

    Can you get Sql Server to return its IP Address

    I'm trying to connect to a server via VPN and I don't know its IP address only its server name. I can query the server via an ASP page that I wrote. Is there a query that will return the IP address of the server? Programming today is a race between software engineers striving to build better...
  14. mwolf00

    Rows lost on import from Excel

    I'm importing data from an excel file and for some reason I only get 1599 rows (there are 1900 in the spreadsheet). Any ideas on what's going on? Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce...
  15. mwolf00

    Memory Leaks From Objects...

    I'm trying to clean up massive amounts of code. The biggest problem that I'm having is pinpointing the cause of memory leaks. I'm pretty sure that the main cause is objects that are not killed correctly (or at all). In the following : set cn = server.createObject("adodb.connection") cn.open...
  16. mwolf00

    IIS Memory - What uses the most?

    I'm trying to clean up a large site that isn't formed too well. We started having memory problems about 2 months ago and they seem to be getting worse. The IT department had to restart the site this morning and it was using 1G of RAM. We watched it go up 30M in just 20 minutes. Something is...
  17. mwolf00

    Emails being blocked by spam filters

    I've created a site for the local soccer association's referees to record game scores. On it there is a very basic feature to send the user their password. Many of these emails are being blocked as spam - perhaps because I am listed as the sender but the server the emails are coming from is...
  18. mwolf00

    Insert / Update Possible Without Row By Row Processing?

    I have a table that holds data from a linked server. It is updated daily. tLease leaseNum effDate expDate When I update it, I need to add any new leases as well as update any leases where the effective date or expiration date has changed. Is there any way to do this without checking each...
  19. mwolf00

    Linked Table Not Returning All Data

    I'm working on a stored procedure that pulls data from a Sybase table via a linked server. When I write a direct query like select * from sybServ.dbo.table1 where field like 'VA008%' I get no result. I do get a result if I broaden the search but I still don't get records above 'VA007%'...
  20. mwolf00

    Excel Object Problems...

    While working with a page that uses an excel object yesterday, it suddenly started to hang. The code is ' create the Excel object Set excelApp = Server.CreateObject("Excel.Application") ' open the spreadsheet file excelApp.Workbooks.Open Server.MapPath("../uploads/lrt/abstracts/" &...

Part and Inventory Search

Back
Top