Home Forums SQL Server 2008 T-SQL (SS2K8) Time - Adding minutes and seconds RE: Time - Adding minutes and seconds

  • December 22, 2012 at 10:40 am

    #1571148

    neevmansoori (12/22/2012)

    We sincerely thank you..

    It Saves a lot of Efforts of mine.:-)

    Yeah, but as old as this post is, I'm not sure that it answers what needs to be done for display purposes if the following data is present...

    Connect Time2 totalTime2

    23:00:00.0000000 01:00:00.0000000

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)