Search results for query: *

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 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. Select Col1, Col2, Col 3 From V_StaticTable Union Select...

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

...'ReleasePlan' index_name index_description index_keys PK__tblSchedRel__369C13AA clustered, unique, primary key located on PRIMARY IDCol /*----------------------------- sp_helpIndex 'IndDemand' -----------------------------*/ index_name index_description index_keys IDX_ChildPN nonclustered...

...int Set @Qty = 1--@pQty Set @ChildPN = '123456R'--@pChildPN --LLA Required (Sum HLA needs) Select @HLAPlanned = sum((coalesce(b.RelPlan,0)* @Qty + coalesce(a.ATR,0)*@Qty) + coalesce(a.WIP,0) + coalesce(OpenPicks,0) + coalesce(c.IndDmdQTY,0)) FROM V_Parent_Child_No_Ind_demand_JH a inner...

Thanks TheBugSlayer. I'll give it a shot.

...+ B.ATR + B.WIP + B.FLEX_SFG - B.SUM_OPICKS) "LLA_AVAIL" FROM ChildPN B GROUP BY B.CHILD_PN ) A ON TV.CHILD_PN = A.CHILD_PN /* Cursor here */ declare c1 cursor FAST_FORWARD for Select TOP 15 Child_PN FROM ChildPN FOR READ ONLY open c1 while (1=1) begin fetch next from c1 into...

Hey Sorwen. I've recorded a macro and am trying to get it into my vb 2005 application. So far, it has been not a fun task.

Thanks RiverGuy. I think that's what I'm going to try to do. Hopefully I can work something out.

Hey all. using VS 2005 and excel 2000 I've create an excel spreadsheet and populated it with the data I need. In the same spreadsheet on a new tab I need to create a pivot table. I've read various articles and looked at examples but I still can't get it to work. Here is how I populate my...

Also I posted a link to this question in the VB6 forum since it does involve both. http://www.tek-tips.com/viewthread.cfm?qid=1617694

Hey RiverGuy. Meaning you would build like a listener into the VB 6 app and some type of "broadcaster" into 2005 app?