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!

Register Log in
  • 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!

Search results for query: *

  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})& '/...
  16. tektipdjango

    Ideas for duty drawback query

    If I Understand well you have 1- JKMT table which is loaded at the beginning by qties you received for different styles (barcoded) : Barcode dutypaid Qty Qtyremaining 20120603 1.2825 20 20 20120603 1.3012 33 33 20120610 1.2793 30 30 20120610 1.2994 56...
  17. tektipdjango

    Line or a value

    LBass means you have to create a formula field! But if you're in CR9 version you can simply go in the format field >>> general >>> in the bottom there is a 'text' button and enter in it the formula -------------------------------------------------- Django [thumbsup] bug exterminator...
  18. tektipdjango

    Ideas for duty drawback query

    For me you're not explaining clearly the problem You said : If you see the table1, for the same "style1" dutypaid value is different(3,1,2). I want to use up the highest paid first for the report. Let's say "Style1" "50" qty has been exported, for that I want to use "3" as duty paid first, then...
  19. tektipdjango

    SQL CONTAINS OPERATOR

    select s.id from emp s,emp1 s1 WHERE CONTAINS(emp.*, '"test"') and s.id=s1.id But why do you do a search on all he columns of emp. eg if you're searching in a descrption column only, it will be a lot quicker : select s.id from emp s,emp1 s1 WHERE CONTAINS(emp.description, '"test"') and...
  20. tektipdjango

    How to create yearly summary view

    Have you try this? select Id, Name, sum(case when (Date<'06/30/2004' and Date>'07/01/2003') then amount else 0) as thisYear, sum(case when (Date<'06/30/2003' and Date>'07/01/2002') then amount else 0) as lastYear, sum(case when (Date<'06/30/2002' and Date>'07/01/2001') then amount else 0) as...

Part and Inventory Search

Back
Top