Forum Replies Created

Viewing 15 posts - 50,716 through 50,730 (of 59,091 total)

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Shamshad Ali (5/7/2008)

    Hello,

    My quewtion is related to replacing loop, I am very interested on this. coz i really want to improve performance and I can't find a way 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)

    May 7, 2008 at 8:34 pm

    #812183

  • RE: Running Total variable resolution

    Heh... remember, you asked what could be done to make this more readable...

    Here's one of your inserts including the indentation I found when I copied it... quick, you're...

    --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 7, 2008 at 8:06 pm

    #812181

  • RE: Running Total variable resolution

    Keith DuAime (5/7/2008)

    ok, I am getting the result set I finally need but it's still pretty messy, I abbreviated all the data needed but this code will run alone. Any...

    --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 7, 2008 at 6:35 pm

    #812171

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    You folks are absolutely the Best! I'm humbled by your awesome compliments and the testing that alot of you have taken the time to do and post.

    I've got 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)

    May 7, 2008 at 8:07 am

    #811808

  • RE: Query Request

    You do realize that code will remove all single rows, correct?

    --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 7, 2008 at 7:50 am

    #811792

  • RE: Cursor not working

    Michael Meierruth (5/7/2008)

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

    Given that Jeff is in luv with cursors, we all really need...

    --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 7, 2008 at 7:41 am

    #811778

  • RE: Dynamic View creation is taking long time

    shamshudheen (5/7/2008)

    Jeff,

    how i use COALESEC function for the following code

    SET @strValList2 = ''

    SELECT @strValList2 = @strValList2 +

    CASE

    WHEN vColName IS NOT NULL THEN '[' + vColName + ']'

    WHEN vColName IS NULL...

    --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 7, 2008 at 7:36 am

    #811769

  • RE: Query Request

    Let's talk about just the ones for Category "A"... which one do you want to keep? The one with the lowest value EmpID or the highest?

    --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 11:35 pm

    #811575

  • RE: Performance Problem

    Ah... understood.

    Dunno why, but ever since I had a boss that wanted to pay me with "virtual money", I've been put off by the word "virtual". 😛 Haven't gotten...

    --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 10:45 pm

    #811563

  • RE: Tally Table

    I don't know about Sergiy, but the only big advantage I've found is that I don't have to convince reluctant DBA's into having two helper tables. I haven't tested...

    --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:59 pm

    #811552

  • RE: Working with strings

    tobe_ha (5/5/2008)

    I would also appreciate any idea that differs from mine.

    The concatenation method show in the article at the following URL might help... I certainly haven't tried it on 100,000...

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

    #811548

  • RE: The T-SQL Quiz

    dfalso (5/6/2008)

    Jeff Moden (5/6/2008)

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

    --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:11 pm

    #811547

  • RE: The T-SQL Quiz

    dfalso (5/6/2008)

    Jeff Moden (5/6/2008)

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

    --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:27 pm

    #811544

  • RE: Tally Table

    Heh... you made my day, Sergiy. I've been trying to convice a DBA on a little side job of those very same points... he's doing things like using calculated...

    --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:00 pm

    #811539

  • RE: transfer data from a text file

    susheereddy (5/6/2008)

    and the file name will be in this format [deposit]yearmonthtime.

    yearmonthtime... so no days in there. The year could be 2 or 4 digits. The month could be...

    --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:55 pm

    #811535

Viewing 15 posts - 50,716 through 50,730 (of 59,091 total)