Forum Replies Created

Viewing 15 posts - 46,186 through 46,200 (of 59,101 total)

  • RE: Cursors for T-SQL Beginners

    Grant Fritchey (1/2/2009)

    Let me reiterate before I whup on you some more 😉

    If that's not a fair "Pork Chops are immenent" warning, then there's no such thing. 😛

    --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 2:28 pm

    #920559

  • RE: Cursors for T-SQL Beginners

    TheSQLGuru (1/1/2009)

    I wonder if poor Mr. Wagner Crivelini is aware of the recent firestorm of posts engendered by an article writer who had the audacity to take on cursors on...

    --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 2:26 pm

    #920558

  • RE: Cursors for T-SQL Beginners

    RBarryYoung (1/2/2009)

    Jeff: I think that the URL link at the end of your last post is messed-up.

    edit: OK, you're too fast for me. Three posts back...

    Thanks, Barry.... it...

    --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 2:22 pm

    #920557

  • RE: Cursors for T-SQL Beginners

    SQLBOT (1/2/2009)

    RBarryYoung (1/2/2009)

    SQLBOT (1/2/2009)

    Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

    It...

    --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 2:20 pm

    #920556

  • RE: Cursors for T-SQL Beginners

    LSAdvantage (1/2/2009)

    In response to sudhanvag, who stated:

    But i want a result like this

    ---------------------------------

    codName (no column name)

    abc 1 281 444 5555 , 55...

    --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 2:14 pm

    #920551

  • RE: Cursors for T-SQL Beginners

    wagner crivelini (1/2/2009)

    My point in this article is "Whenever you suspect your code is not running as expected, no matter it uses cursors or not, you should check your code'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 2:11 pm

    #920548

  • RE: Cursors for T-SQL Beginners

    robert.letts (1/2/2009)

    Excellent article on cursors, Wagner.

    Here is a weird problem that made me choose a cursor. The incoming data was in a header / detail format. The header had 5...

    --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 2:01 pm

    #920543

  • RE: Cursors for T-SQL Beginners

    Linson.Daniel (1/2/2009)

    ...nevertheless worth a look and definitely an alternate solution to cursors.....

    No! It's NOT! It still uses a declared loop and it's still just as bad as...

    --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 1:56 pm

    #920538

  • RE: Cursors for T-SQL Beginners

    wagner crivelini (1/2/2009)

    In fact, concatenating strings will not do on this example.

    This works when you have one scalar value to return, instead of a whole table.

    But there are workarounds, 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 1:54 pm

    #920537

  • RE: Cursors for T-SQL Beginners

    sudhanvag (1/2/2009)

    Extending the table structure given in the articlehttp://www.sqlservercentral.com/articles/cursors/65136/%5D

    I have added an extra table for UserListing.

    CREATE TABLE dbo.tblUser ( codUser INT, codName VARCHAR(20),PRIMARY KEY (codUser));

    insert into dbo.tblUser values (1, 'abc');

    insert...

    --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 1:50 pm

    #920533

  • RE: Cursors for T-SQL Beginners

    slippers (1/1/2009)

    Hi

    One question: if considering whether to use Cursors or alternatives, how does trigger firing influence the decision?

    I mean, when using a cursor to perform an insert statement with...

    --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 1:43 pm

    #920529

  • RE: Cursors for T-SQL Beginners

    battelofhalfwits (1/1/2009)

    Wow...

    Two things

    1) Never use Cursors! Looping through a temp table takes less overhead than a Cursor; especially when you are working on a 24/7/365 server where you really...

    --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 1:40 pm

    #920527

  • RE: Cursors for T-SQL Beginners

    JRoughgarden (1/1/2009)

    OK, I'll take up the case for using cursors for some types of processing. I've posted below a copy of a stored procedure I just finished. It uses 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 1:37 pm

    #920526

  • RE: Cursors Be Gone!

    Ok... from JacRobert's description, Create Table statement, and a couple of good guesses like the fact that since all the columns are nullable, there's no primary key, here's a chunk...

    --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 1:26 pm

    #920521

  • RE: Cursors Be Gone!

    Heh... an I'll maintain that what he said is nutty for mor than 1 reason. Consider the title and the first sentence...

    [font="Arial Black"]Let's deprecate UPDATE FROM! [/font]

    I guess that...

    --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 1:08 pm

    #920510

Viewing 15 posts - 46,186 through 46,200 (of 59,101 total)