Home Forums SQL Server 2008 SQL Server 2008 - General Help with next date in SQL query RE: Help with next date in SQL query

  • May 20, 2013 at 5:34 pm

    #1616815

    Tyekhan (5/20/2013)

    Yes that's what i want, if anyone can help me with it.thanks

    alezar (5/20/2013)

    Hi, as Sean asked it will be great if you could improve description of your req.

    What I understand is that if you have two different rows for NAME1, one with calldatetime first of may and the second fifth of may, you want to show both in the result. If more rows are available you want to show always the first date and the following.

    Please confirm if this is correct.

    Great. What do you want to do if NAME1 has 3 calls each on the first and fifth of May?

    --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)