Forum Replies Created

Viewing 15 posts - 36,361 through 36,375 (of 59,099 total)

  • RE: Date Gap Problem

    WayneS (10/17/2010)

    Jeff Moden (10/17/2010)

    WayneS (10/17/2010)

    This works, but the performance is atrocious.

    Because of the very large datespan from any date in this century to 9999-12-31, I'm thinking that my ol' friend...

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

    October 17, 2010 at 10:23 pm

    #1238213

  • RE: Date Gap Problem

    WayneS (10/17/2010)

    Jeff Moden (10/17/2010)

    Sorry... forgot to print out the results...

    MemberIDStartDateEndDateGap

    12006-10-01 00:00:00.0002007-12-31 00:00:00.0000

    12008-01-15 00:00:00.0002008-12-31 00:00:00.00015

    22007-02-03 00:00:00.0002007-12-31 00:00:00.0000

    22008-01-15 00:00:00.0002008-12-31 00:00:00.00015

    32006-10-01 00:00:00.0002007-09-30 00:00:00.0000

    32008-01-01 00:00:00.0002008-12-31 00:00:00.00093

    Jeff, are these gaps correct? By my calc, there...

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

    October 17, 2010 at 10:10 pm

    #1238211

  • RE: Date Gap Problem

    WayneS (10/17/2010)

    This works, but the performance is atrocious.

    Because of the very large datespan from any date in this century to 9999-12-31, I'm thinking that my ol' friend the Tally Table...

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

    October 17, 2010 at 10:06 pm

    #1238209

  • RE: Date Gap Problem

    Sorry... forgot to print out the results...

    MemberIDStartDateEndDateGap

    12005-10-01 00:00:00.0002006-09-30 00:00:00.0000

    12006-10-01 00:00:00.0002007-12-31 00:00:00.0000

    12008-01-15 00:00:00.0002008-12-31 00:00:00.00015

    12009-01-01 00:00:00.0009999-12-31 00:00:00.0000

    22005-10-01 00:00:00.0002006-09-30 00:00:00.0000

    22006-10-01 00:00:00.0002007-09-30 00:00:00.0000

    22007-02-03 00:00:00.0002007-12-31 00:00:00.0000

    22008-01-15 00:00:00.0002008-12-31 00:00:00.00015

    22009-01-01 00:00:00.0009999-12-31 00:00:00.0000

    32005-10-01 00:00:00.0002006-09-30 00:00:00.0000

    32006-10-01 00:00:00.0002007-09-30 00:00:00.0000

    32008-01-01 00:00:00.0002008-12-31...

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

    October 17, 2010 at 9:57 pm

    #1238206

  • RE: Date Gap Problem

    TheSQLGuru (10/17/2010)

    My brain is mush and I just cannot work this one out. I need a good solution to find any gaps between enddate and startdate > 30 days...

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

    October 17, 2010 at 9:53 pm

    #1238205

  • RE: working with multiple dataset withing a table in SSRS

    Doug Lane (10/13/2010)

    Jack isn't saying multiple datasets are bad; he's saying trying to blend multiple datasets in the same table control is bad. RS just wasn't designed to take...

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

    October 17, 2010 at 7:37 pm

    #1238198

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/14/2010)

    The green value, if there is one, comes not from you getting ebooks, but from 1000s of people doing this. Less paper, less energy, less...

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

    October 17, 2010 at 7:04 pm

    #1238197

  • RE: Are the posted questions getting worse?

    WayneS (10/14/2010)

    "Don't try this at home... we're professionals!"

    Heh... I have the perfect SQL subject for that... Quirky Update. 😀

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

    October 17, 2010 at 6:57 pm

    #1238196

  • RE: Calling a Stored Procedure inside a stored procedure

    Heh... screw it. If you really insist on doing it using RBAR, do it in C#. 😀

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

    October 17, 2010 at 6:47 pm

    #1238194

  • RE: Are the posted questions getting worse?

    WayneS (10/16/2010)

    GilaMonster (10/16/2010)

    Swap? http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx

    Me: Run CheckDB and and post the full and unedited results

    OP: I have used that command and it returned about 3000 line of error code. This is...

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

    October 17, 2010 at 6:40 pm

    #1238192

  • RE: Are the posted questions getting worse?

    GSquared (10/15/2010)

    CirquedeSQLeil (10/15/2010)

    GSquared (10/15/2010)

    Yesterday, whilst commuting, I was actually thinking about setting up a video camera on my dashboard, and blogging the "good parts".

    Then I realized it would contain at...

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

    October 17, 2010 at 6:37 pm

    #1238191

  • RE: Are the posted questions getting worse?

    Alvin Ramard (10/15/2010)

    Grant Fritchey (10/15/2010)

    GilaMonster (10/15/2010)

    And just when I thought the situation at That Client couldn't get any worse....

    <headdesk><headdesk><headdesk><headdesk>

    (No, I'm not going into details, it's a little too sensitive a...

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

    October 17, 2010 at 6:34 pm

    #1238190

  • RE: Sending multiple rows to the Database from an Application: Part I

    I'm not a GUI/App programmer so I'll have to find another way to test what you propose, Solomon. Shouldn't be too difficult, though.

    If I were an App programmer, I'd...

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

    October 17, 2010 at 6:19 pm

    #1238187

  • RE: Sending multiple rows to the Database from an Application: Part I

    Gosh... my first take on this is all the people in this discussion citing XML as a good way to do this. Would you folks mind providing a little...

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

    October 17, 2010 at 3:51 pm

    #1238164

  • RE: Sending multiple rows to the Database from an Application: Part I

    Daniel Macey (8/18/2009)

    Good to see an article on a tricky and quite important piece of code.

    Although, with SQL Server 2008 around, I am surprised that you did not mention the...

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

    October 17, 2010 at 3:41 pm

    #1238163

Viewing 15 posts - 36,361 through 36,375 (of 59,099 total)