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

    Index needed on large table - grouping query

    Hey folks, I am porting an expense reporting application from MS SQL Server 2000 to Oracle 9.2.0.5. I have a large base table which contains 1.3M expense records for my company. Here is the schema: EXPENSEAMT NUMBER(17,2) - money! RCC CHAR(9) - Actual Organization charged...
  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

    Hi folks, I am having trouble creating a delete query where I need to match on a number of customer criteria and delete all 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...
  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

    It's quite possible. I've had issues with SQL Server and RAM resources where I could not run, coincidentally, this exact same SP due to the SQL Server service taking all 2GB of my system memory. I can't remember the exact error message now , but it was an indicator that new RAM could not be...
  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

    Hi, I'm trying to join three (actually more) tables together with the purpose of getting user id and sums of various integers. Here's what I'm doing with 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...
  16. ks1392

    Kicking off DTS package from T-SQL

    Hi, I've been using a stored procedure I found on databasejournal.com http://www.databasejournal.com/features/mssql/article.php/1459181 for some time. The stored procedure, spExecutePKG, allows you to kick off a DTS package from withing a T-SQL statement. The procedure was working fine up...
  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