DateDiff problem

From: Strugglin' (Strugglin'_at_discussions.microsoft.com)
Date: 11/05/04

  • Next message: jj: "help! fail to run aspSample.setup.vbs for EQ sample!" 
    Date: Fri, 5 Nov 2004 06:27:03 -0800

    I have a db with a table that records details about order transactions. The
    main columns I am concerned about are the "Transacton_Type" column and the
    "Date_Time" column. Each order has more than one transaction/rows in the
    table (ie. Pending, Shipped, etc...), with each transaction having its' own
    time stamp (as opposed to a table with a Pending column and a Shipped
    column). How can I use the DateDiff function to give me the difference
    between the Pending date and Shipped date for each Order (uniquely referenced
    in a "P.O." column) if the timestamp for each transaction exists in the same
    column. Is this even possible?

  • Next message: jj: "help! fail to run aspSample.setup.vbs for EQ sample!"

    Relevant Pages

    • RE: Master/Detail Transactions
      ... If any of the updates fails, ... pending parent and child rows within the scope of a transaction, ... cascade newly retrieved parent identity values down to pending child rows ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Named Transactions
      ... -- WRAP THE CHANGES IN A TRANSACTION, UNLESS ONE IS ALREADY PENDING ... begin transaction <SomeName> ... > How can I rollback Transaction a? ...
      (microsoft.public.sqlserver.programming)
    • Re: SqlTransaction and Dispose
      ... the transaction will be rolled back if it is pending when disposed. ... You can see this for yourself using Reflector ... HTH, ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Concurrency Help
      ... All you need to do to implement it is to add a TimeStamp ... only client/user X has rights ... Another approach is to use pessimistic locks. ... Then the operation is wrapped inside a transaction. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Combine Secure 3DES Encryption with ability to count occurence of known plaintext - how to accom
      ... >The problem I have is the limited capabilities of the HSP. ... When I have a transaction, ... add, timestamp) to set B. ... Ecould be a deterministic encryption algorithm, or it ...
      (sci.crypt)