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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tektipdjango

  1. tektipdjango

    Complex Comparisons

    Oops this is a french formula In english this must be =COUNT(MATCH(range1;range2;0) Hope this help ! -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  2. tektipdjango

    Complex Comparisons

    if you have 2 ranges in which you want to know how many cells are the same try the =NB(EQUIV(range1;range2;0)) confirm by ctl+enter to get a matricial formula -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  3. tektipdjango

    Copy down takes a long way. What is quicker

    if you want to copy the formula of the first line in all the rows, you'd better put your formula in a name (ex 'calc') and change in the 1 line the formula's like this =calc to get the right formula select the first cell of the first line then record the code to change the formula via record...
  4. tektipdjango

    Crystal Reports XI vs. SQL Server Reporting Services

    the best is to use SQL server to make the queries and CR for the design of the Printing. In fact CR is not efficient if you have subqueries. In CR they are treated by subreports but they are very inefficient as they need a dialog with SQLServer to get each row. For instance essuming you have 3...
  5. tektipdjango

    Need opinion on this logic

    ViperPit, your locking logic is better but you still have the problem that the server is working with a list established before the orther servers have worked with the rest of the free clients. For this I think you have to end the loop and begin a new search for a a free client before...
  6. tektipdjango

    Need opinion on this logic

    Hi ViperPit, For me your logic seems a bit strange : First you check the clients to look for those to process, and get a list of them Then you lock all your clients to perform the task with only one, then you release all your clients and treat the next client It seems that the 19 other servers...
  7. tektipdjango

    Access and sql server, performance question

    Here is my problem Thre is an app (ERP) running with sql server, connected with several sites. I want to give the users the ability to look at tables in the database without updating rights, and I think Access ùay be a good solution for this, with runtime and menus giving read-only forms. For...
  8. tektipdjango

    Date Issue

    I assume if you're on May 13th, you want the records from May 10th 00:00:00 to May 10th 23:59:59 So try : declare @startdate datetime declare @endDate datetime set @startDate= convert(datetime,convert(char,getdate(),101),101)-3 set @endDate=@startDate+1 SELECT ...,Date_Submitted FROM...
  9. tektipdjango

    How to Query on Server

    assuming as you said the format of the date like 'YYYY/MM/DD HH24:MI:SS' your query must be something like this if you want the records not earlier than 1/1/2004 : SELECT blah blah FROM blah blah WHERE .... and ("SHIPMENTS"."SHIPDATE" >= '2004/01/01') ORDER BY blah blah If you want...
  10. tektipdjango

    Expanding a complicated query

    It's unclear if the tblBoat table is the result of the tblAffects selection criterias. If this is the case, to get the results you want, you just have to do select ServiceID,Status from tblBoat where Boat=101 -------------------------------------------------- Django [thumbsup] bug...
  11. tektipdjango

    In and Not In problems...

    THE BEST RESULT FOR SPEED IS NOT WITH A SUBQUERY? BUT WITH A JOIN SELECT custumer.id,name FROM custumer left join sales on custumer.id=sales.id where sales.id is null -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  12. tektipdjango

    Update Problem

    maybe there a weird situation between the set statement WH_CRC1 = s.WH_CRC1, and the join clause d.WH_CRC1 <> s.WH_CRC1 both in the same query -------------------------------------------------- Django [thumbsup] bug exterminator tips'n tricks addict
  13. tektipdjango

    Still problems with Stored Proc...

    You have a problem with the endPeriod calculation. If you write month/30/year what about february which has less than 30 days, and what with the months of 31 days? Furthermore what about the cbiper field? You need to convert it , maybe it's a string like yymmdd thet you can check like cbiper...
  14. tektipdjango

    Ideas for duty drawback query

    donutman's drawbackTable is a good solution but it needs, as in Shal2's sample, to completely know how the drawback is calculated, thet is, how are "exported" the different dutyChargedItems. eg in my sample above, the first export of 8 pieces will give one drawback record, and the second one of...
  15. tektipdjango

    Passing Parameters

    to use indexes avoid using them INSIDE formulas like you do in : Year({BT_MONTHLY_CUSTOMER.CALL_START_DATE}) change your selection this way (I try in pseudo_code as I haven't CR at the moment so check syntax and function spelling) ({BT_MONTHLY_CUSTOMER.CALL_START_DATE} >= totext({?Month})& '/...

Part and Inventory Search

Back
Top