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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.