Recent content by ruckrock

THanks for the reply....I ended up figuring this one out a couple weeks ago. The customer data table that I was using had over 200k records in it, but I was able to filter out the records I didnt need before I started looping, which seemed to have solved the problem. The script still took...

If you want/need to see the whole code for this proc, please see my previous thread http://www.tek-tips.com/viewthread.cfm?qid=1387353

No, this is not a homework assignemtnt. I have been giving the task at my job to rework a stored_proc that sends values to Crystal Report in order to optimize its performance. Right now, its generating reports kinda slow for some search criteria. Basically, I am trying to rework this...

Sorry, here is the full thing select * from user_master where user_id IN (select user_id from user_role_job where job_id='000000000102' and user_id IN (select user_id from user_location where location_id IN (select location_id from gen_location where location_id='000009'))) and...

Just to let you know....we use CR here at my job and its a pain in the ass. Anytime you change something and have to recompile it, its not fun. I mean, it does server is purpose I guess, but its rather technical and time consuming to use.

Hi, I was wondering what the best query conversion for the following code would be if I had to use JOINS instead of using nested IN statements. I know job_id is more selective than the location_id, so job_id should be in the first where condition I suppose, but my JOIN knowledge isnt what it...

Hi everyone…this is a tough one. You guys have been such a help before, hopefully you can point me in the right direction now. I have a Report I am working on that uses a stored procedure to pass along all off the parameters to the reporting generator (Crystal Reports) and I was currently...

Hi, I currently am building script to randomize all a table of patient data. The table has over 170,000 records in it and my script is having problems finishing. If I use it on 40,000 or less records, it will work fine. If i try it on all the records, it goes on forever. Can anyone see...

Hi, I have a quick question. I have a SQL Server database with customer data in 1 table. I want to use this 'live' data for a testing database, but need a way to randomize the customer info. I figured out ways to do it for SSN# and telephone #, as well as address, but I am stuck on the...