Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jadams0173

    Find markup value in dollar range

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

    Find markup value in dollar range

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

    Union query question

    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?
  4. jadams0173

    Union query question

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

    SQL using tables from two MDBs

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

    Union query question

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

    Union query question

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

    wait for a process to finish

    Look Here
  9. jadams0173

    WNetCancelConnection2 return code question

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

    Speed up query

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

    Speed up query

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

    Speed up query

    ...'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...
  13. jadams0173

    Speed up query

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

    Eliminate CURSOR!!! SLOW

    Thanks TheBugSlayer. I'll give it a shot.
  15. jadams0173

    Eliminate CURSOR!!! SLOW

    ...+ 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...
  16. jadams0173

    Excel automation. Create Pivot Table

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

    VB 2005 Execute timer in VB 6 code

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

    Excel automation. Create Pivot Table

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

    VB 2005 Execute timer in VB 6 code

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

    VB 2005 Execute timer in VB 6 code

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

Part and Inventory Search

Back
Top