Forum Replies Created

Viewing 15 posts - 46,201 through 46,215 (of 59,101 total)

  • RE: Cursors Be Gone!

    Cool... that 1899-12-30 thingy about the time also explains why you add 2 days to the combination of date and time. Thanks, Jac.

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

    January 2, 2009 at 11:51 am

    #920468

  • RE: Cursors Be Gone!

    And, just to be 100% clear... would you give a couple of actual examples of the various cookie formats you're expecting so I can make a good cross section of...

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

    January 2, 2009 at 10:52 am

    #920440

  • RE: Cursors Be Gone!

    Matt Whitfield (1/2/2009)

    Jeff Moden (1/2/2009)

    jacroberts (1/2/2009)

    TheSQLGuru (1/2/2009)

    jacroberts, I am pretty sure (>90%) that your problem can be solved with a self-join set-based solution. If the table is properly indexed...

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

    January 2, 2009 at 10:46 am

    #920435

  • RE: Cursors Be Gone!

    Phil Factor (1/2/2009)

    Jeff

    I'll take that challenge and I'll take all comers.

    [p]I've got a 'quirky' Update solution that motors. I'd love some real data to run comparative timings on.[/p]

    Heh... not fair,...

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

    January 2, 2009 at 10:17 am

    #920410

  • RE: Cursors Be Gone!

    TheSQLGuru (1/2/2009)

    Jeff Moden (1/2/2009)

    Alexander Kuznetsov (12/24/2008)

    Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or 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)

    January 2, 2009 at 10:11 am

    #920402

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    TheSQLGuru (1/2/2009)

    jacroberts, I am pretty sure (>90%) that your problem can be solved with a self-join set-based solution. If the table is properly indexed that solution could well...

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

    January 2, 2009 at 10:04 am

    #920394

  • RE: Cursors Be Gone!

    Matt Whitfield (1/2/2009)

    Hmmm. Just wrote a massive reply and the session timed out!!

    Oh well. The long and short of it was:

    1) It's pretty trendy to bash microsoft, but I'm going...

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

    January 2, 2009 at 9:42 am

    #920371

  • RE: Cursors Be Gone!

    Lawrence (1/1/2009)

    Jeff, I've been following this post as I am a SQL Noob and walked into a position where cursors are everywhere and I'm trying to understand when/when not to...

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

    January 2, 2009 at 9:29 am

    #920359

  • RE: Cursors Be Gone!

    Tom.Thomson (1/2/2009)

    I think you are being a bit unfair to him,Jeff.

    Heh... Yet, you just agreed with everything I said about UPDATE. 😉 The real fact of the matter 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)

    January 2, 2009 at 9:19 am

    #920349

  • RE: Cursors Be Gone!

    jacroberts (1/2/2009)

    Jeff Moden (1/1/2009)

    One of my fellow MVP's... Go back and look at Grant's posts... you'll figure it out. I've probably said too much, already.

    When you say "fellow MPV's"...

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

    January 2, 2009 at 9:12 am

    #920338

  • RE: Cursors Be Gone!

    Alexander Kuznetsov (12/24/2008)

    Actually in most cases the best alternative is a loop written in a modern language such as C#, not a T-SQL WHILE loop or a CURSOR. Not only...

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

    January 2, 2009 at 9:05 am

    #920336

  • RE: Cursors Be Gone!

    repicurus (12/24/2008)

    I would be happy to contribute TWO examples that I do not think could be accomplished WITHOUT cursors.

    There are several places where I agree that at least 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)

    January 2, 2009 at 9:00 am

    #920327

  • RE: Ok, its their first day on the job.

    BWAAA-HAAA!!! The next problem is... finding a good book! 😉 Many of the folks that write such books have some pretty severe ego problems themselves. 😉

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

    January 1, 2009 at 7:41 pm

    #920071

  • RE: getting all records between 2 fridays of a given date

    Piotr Rodak (1/1/2009)

    Now, that's a cunning trick I see now Jeff :w00t:

    Not earlier than yesterday I said to myself 'one day I have to get those dateadd-datediff calculations sorted out'.

    And...

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

    January 1, 2009 at 7:37 pm

    #920069

  • RE: Partitining an existing table

    I'm not sure what you're talking about. A clustered index IS the data and adds almost nothing to the size of the table.

    My feeling is that you've not done...

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

    January 1, 2009 at 7:33 pm

    #920068

Viewing 15 posts - 46,201 through 46,215 (of 59,101 total)