Recent content by jadams0173

Thanks SkipVought. I have it working now, many thanks!!

I'm tring to do something that is similar to thread68-1615386 but I am not having much luck. I'm using excel 2010 and I am trying to do this. Given a lookup table Range markup 0-10 4 11-20 3 etc I need to take a value and return the markup. So $10.36 would return 4. $11.89 would...

Yes there are parenthesis around NoLock. That was my error. Short of redisgning how the imports work, which won't happen, is there anything I can do to eliminate this?

I guess, as usual, I didn't give enough detailed information. I am actually using views in my sql since that's the way it was setup. The views are written like Create View dbo.V_StaticTable as Select * from StaticTable NOLock So I then query the view so the nolock hint is already in use...

If you linked the tables into one of the databases wouldn't unmatched query wizard then be able to run? Even though one of the tables will be linked it is still in the "same" database? One way I've done this in the past, which may not be the best solution, is to query each database and have two...

Hey gmmastros. Unfortuantly I can not change how the data is loaded or even investigate. I know the data is read from a DBF file using a DTS package. That's the reason I'm trying to eliminate the blackout time.

Using SQL 2000 I have two tables. At the begging of the day both tables are identical. However, at mid day the dynamic table updates and it takes about 40 minutes to load the updated data (about 2 million rows). During this reloading time, my application is in a blackout time since this huge...

Look Here

Im using vb 2005 and have a question about the return code I'm getting from WNetCancelConnection2. I am getting a huge numbers like 1244963895005677770 and 1239615827498500096 It is disconnecting my network share as I expect but why the weird return results? Private Declare Function...

Now it is less than 1 second. Now when I run it through with the cursor it runs in 1:30 seconds. But when I run from VB it still times out and runs > 10 min. and then I kill it.

I removed every Rtrim in v_parent_child_JH. I got the same record count back and the speed was 0 seconds on both. Here are the indexs on Scheduler_Parent_Child index_name,index_description,index_keys IDX_COMPONENT,nonclustered located on PRIMARY,Component IDX_Level,nonclustered located on...

Hey George! I ran the index tuning wizard and it dropped one of my existing indexs and added 2 more. The query then ran in 1:50 seconds and then in 1:35. I also updated the statistics on each table. But for some reason when I execute this SP from vb6 it goes unresponsive and times out. I...

Hey all. I'm using sql 2000. I have a query that I need to speed up. It only takes about 3 seconds to run it but I'm running in a cursor at the moment..I know that's bad. It takes about 26 minutes to run and need to reduce that as much as possible. I'd post the execution plan but I'm not...

Thanks TheBugSlayer. I'll give it a shot.

using sql 2000 I've been working through a report and managed to get to where I need. Only problem is I used a cursor! It is VERY slow. Anyone willing to try to help me get rid of the cursor. Here is the query. Declare @Parent Varchar(25),@ChildPer int,@HLA_REQ int,@LLANeeded int,@ChildPN...