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

    Index needed on large table - grouping query

    ...calls 1503 db block gets 12528 consistent gets 33797 physical reads 128 redo size 14013599 bytes sent via SQL*Net to client 153207 bytes received via SQL*Net from client 13753 SQL*Net roundtrips to/from client 48 sorts (memory)...
  2. ks1392

    DELETE query - all but MAX of ID

    Right, but how would I isolate the max(id) field so as to put it in an IN clause using something like the above query as a subquery to isolate out the max(id)?
  3. ks1392

    DELETE query - all but MAX of ID

    ...records but the MAX of the unique identifier for each grouped result. Here is a sample query: select left(btn,6), campaignname, custname, count(*) quantity from repaircalls inner join campaigns on repaircalls.campaignid = campaigns.campaignid group by left(btn,6), campaignname, custname...
  4. ks1392

    cftransaction and deadlocks

    Folks, I am using cftransaction on CF 5.0 paired with SQL Server 2000 to pick up a particular customer call record from within a table, then updating that record to a 'locked' status so that it cannot be picked up by anyone else. I keep getting deadlocks when two users hit the .cfm template at...
  5. ks1392

    Kicking off DTS package from T-SQL

    ...to work. I have since set a hard ceiling on SQL Server's memory usage, plus we do weekly reboots during a maintenance window. We also run an AIX box with a *very* old Informix database on it. It's slow as hell but I've never seen it go down or give me the trouble that SQL Server does...
  6. ks1392

    Kicking off DTS package from T-SQL

    I've never seen that specific error, but is tempdb set up for a max file size or unrestricted growth? Also, is the filesystem it's on very close to full?
  7. ks1392

    Kicking off DTS package from T-SQL

    The only other item I can think of is to, if possible, change from @IntSecurity=1 to 0, and then use the optional user/pass parameters to see if you can run it that way.
  8. ks1392

    Kicking off DTS package from T-SQL

    Honestly, I can't remember exactly since it's been so long. Assuming you're using the scripts I linked to at the database journal site, my T-SQL successfully runs like this: EXEC spExecutePKG @Server='ServerName', @PkgName='PackageName', @IntSecurity=1
  9. ks1392

    Abit VA-10 problems

    I’m putting together a pretty simple box with the following parts: Abit VA-10 1.2 BIOS rev 16 (unflashed) XP2600+ retail Antec SmartPower 350W PSU Currently 1x 256MB Mushkin PC2700 - will be 2x 256MB Corsair PC3200 Western Digital WD400 40GB HDD (Pimary Master) Toshiba DVD-ROM SD-M1712...
  10. ks1392

    pushing text from popup to opener

    I'm using ColdFusion on the server side. I hadn't thought to do this using CF. I will work it from that angle with CF's regex functions. I did try using the JS 'escape' function and while it hex encoded all the spaces, etc. it still failed when I handed it a single quote. Hey your sig is an...
  11. ks1392

    pushing text from popup to opener

    Hi, I'm relatively new to JS. I have a function that pops up a window, then from the popup a user will select some text. The text will then be placed in a <textarea> tag in the opener as the popup closes. The (very simple) function is: function put_back(form,field,text) {...
  12. ks1392

    Kicking off DTS package from T-SQL

    Since my post I have figured out the nature of the error -- the T-SQL call was structured incorrectly. Thanks, Kerr
  13. ks1392

    Outer join and sums

    Shucks, that's what I figured. I wasn't aware of the *= syntax being deprecated - thanks for the tip.
  14. ks1392

    Need SQL to select from 2 tbl's WHERE NOT equal to each other

    If I understand correctly, it looks like you can do this with a subquery. Try something like this: SELECT PictureID FROM News_Article_Pictures WHERE PictureID NOT IN ( SELECT PictureID FROM News_Articles ) This is basically grabbing all the PictureIDs from the News_Articlas table and...
  15. ks1392

    Outer join and sums

    ...a two table join, which works fine. SELECT pcs.csr_sbcuid, SUM(b.tkts_scrnd) FROM personnel_csb_snapshot pcs, bo_tkts_scrnd b WHERE pcs.csr_lmos *= b.lmos AND pcs.themonth *= b.themonth AND pcs.theyear *= b.theyear AND csr_job_function like 'rts' AND pcs.themonth = '12' AND pcs.theyear =...
  16. ks1392

    Kicking off DTS package from T-SQL

    ...from withing a T-SQL statement. The procedure was working fine up until a few days ago. Now, when I try to run it I receive the following error: *** Execute failed OLE Automation Error Information HRESULT: 0x80040428 sp_OAGetErrorInfo failed. Not only is the spExecutePKG proc...
  17. ks1392

    Best Practices for Column Names

    Ahh, style -- thanks very much for your help!
  18. ks1392

    Best Practices for Column Names

    r937, Thanks -- I've been half-heartedly trying to do this for awhile. Question -- I understand all but the datefield,120 portion -- specifically the 120.
  19. ks1392

    Best Practices for Column Names

    Ahh, glad I caught this thread. I have question along the lines of breaking a datetime field down into Day/Month/Year. I do this in a number of views, but I am wondering if I can CAST/CONVERT some date functions to create a datetime field in a view with the time as 00:00:00.000. I've not had...
  20. ks1392

    2 LAN Connections Possible on Win2K?

    bcastner - thanks for the link to the netsh walkthrough. Even if one isn't too comfortable with batch files, this is a pretty easy way to set up multiple TCP/IP environments. I too experimented with Hardware profiles on my laptop in an attempt to set up separate DHCP and dedicated IP...

Part and Inventory Search

Back
Top