Forum Replies Created

Viewing 15 posts - 50,731 through 50,745 (of 59,091 total)

  • RE: Tally Table

    Outstanding, Sergiy... you've reminded me of a couple of questions that I've always wanted to ask about such multi-purpose (Numbers/Tally + Date table + other) tables... guess now's as good...

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

    May 6, 2008 at 6:38 pm

    #811533

  • RE: spid identified as being blocked by itself

    Well, at least it has some documentation to let you know what's going on... that's a start.

    You already know the bad news... this code has joins of concatenated address columns...

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

    May 6, 2008 at 6:14 pm

    #811528

  • RE: Parsing a cell into multiple rows

    wdillon (5/6/2008)

    Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do you ever...

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

    May 6, 2008 at 5:41 pm

    #811525

  • RE: Parsing a cell into multiple rows

    Matt Miller (5/6/2008)

    Steve's had a buzzer implanted on Jeff, that goes off each time a new post is added...:)

    So THAT's what it is! Here I was trying to cut...

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

    May 6, 2008 at 5:32 pm

    #811523

  • RE: Tally Table

    Thanks for the info, guys! 🙂

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

    May 6, 2008 at 4:43 pm

    #811514

  • RE: Stored Procedure - which is faster/better?

    matt6749 (5/6/2008)

    Yeah! Got it working in SQL Server! Thanks to Barry, Matt, Jeff, and this forum!

    DECLARE @sql nvarchar(4000)

    SET @sql = 'SELECT ID, Name, Address

    FROM

    (SELECT ID, Name, Address,

    ROW_NUMBER()...

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

    May 6, 2008 at 4:41 pm

    #811513

  • RE: transfer data from a text file

    Ok... I'll try a third and final time... I'm trying to help you do this using xp_CmdShell and Bulk Insert, as you requested. I asked you a couple 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)

    May 6, 2008 at 9:09 am

    #811282

  • RE: The T-SQL Quiz

    Ummm... you certainly don't need a cursor to transpose a table. Cross-tabs, dynamic cross-tabs, and the occasional use of the Pivot function do the job in a nice set...

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

    May 6, 2008 at 9:03 am

    #811275

  • RE: Tally Table

    Holy Moly... that's one heck of a lot of analysis. Did they actually get anything useful out of all 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)

    May 6, 2008 at 8:22 am

    #811230

  • RE: The T-SQL Quiz

    dfalso (5/6/2008)

    {I was encouraged to discuss my position a little better}

    I'll attempt to give an example to illustrate (btw, this also illustrates a candidate for an appropriate use of cursors):

    Think...

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

    May 6, 2008 at 8:18 am

    #811226

  • RE: Tally Table

    GSquared (5/6/2008)

    Dateadd lists of datetimes. For example, if you need a second-by-second list of all times in a month, or a quarter. (10,000 seconds is a little 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)

    May 6, 2008 at 7:31 am

    #811186

  • RE: Cursor not working

    Now, you know why I've chosen the Avatar that I have... 🙂

    Cursors = RBAR

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

    May 6, 2008 at 6:53 am

    #811157

  • RE: Running Total variable resolution

    The reason why the variable had the value subtracted twice is to make it work properly... you wanted the running total to NOT include the current value and that's one...

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

    May 6, 2008 at 6:24 am

    #811141

  • RE: Cursor not working

    Kent Waldrop (5/5/2008)

    Hmm 99.99%. Maybe as far as cursors go you "can't loathe them enough."

    Heh... to be clear, I've never written a cursor except to show how slow they...

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

    May 6, 2008 at 6:15 am

    #811132

  • RE: transfer data from a text file

    Sorry... didn't know that...

    Still, I posted some questions on that other thread because I need more info to help you. Any answers on those?

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

    May 6, 2008 at 6:12 am

    #811128

Viewing 15 posts - 50,731 through 50,745 (of 59,091 total)