Recent content by ks1392

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

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)?

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

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

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

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?

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.

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

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

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

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) {...

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

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

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

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