Forum Replies Created

Viewing 15 posts - 46,981 through 46,995 (of 59,095 total)

  • RE: Functio to get Amount in words.

    rbarryyoung (11/27/2008)

    Jeff:

    Your function is called "NumberToWords" but you are calling "MoneyToWords", is this just a typo or am I missing something?

    Heh... guilty as charged. The Phat-Phinger-Phairy made...

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

    November 27, 2008 at 8:52 pm

    #904538

  • RE: The Numbers Table

    jacroberts (11/27/2008)

    Ok, I have recently written some code that uses an RBAR TVF to increase the efficiency and speed of a query.

    Here's my example:

    We had a table 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)

    November 27, 2008 at 8:25 pm

    #904536

  • RE: Functio to get Amount in words.

    For the most part, Yes. On concatenation of such a small number of parts, not 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)

    November 27, 2008 at 4:47 pm

    #904508

  • RE: Functio to get Amount in words.

    Very cool code, Chris... your' guy's efforts made me finish up what I started and it looks nothing like the original code I posted... I couldn't stand the fact 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)

    November 27, 2008 at 4:37 pm

    #904506

  • RE: Functio to get Amount in words.

    Chris Morris (11/27/2008)

    Jeff Moden (11/27/2008)

    Chris Morris (11/27/2008)

    Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, 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)

    November 27, 2008 at 3:04 pm

    #904497

  • RE: Functio to get Amount in words.

    Chris Morris (11/27/2008)

    Here's a 2k/2k5-friendly version with a permanent lookup table. It translates 30,000 numbers from a standard tally table, in both SQL Server versions, in about 4 seconds.

    Ummm......

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

    November 27, 2008 at 11:35 am

    #904446

  • RE: The Numbers Table

    Lynn Pettis (11/27/2008)

    And two, someone is going to come along and see your code in your RBAR TVF and use it somewhere else and it won't be effecient at all.

    Heh......

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

    November 27, 2008 at 11:10 am

    #904439

  • RE: Calculate the Running Total for the last five Transactions

    Lynn Pettis (11/26/2008)

    Good article, but let's take another approach and see what we see.

    Heh... you beat me to it, again. 😉

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

    November 27, 2008 at 11:02 am

    #904436

  • RE: Calculate the Running Total for the last five Transactions

    Hugo Kornelis (11/27/2008)

    What I was refering too is the lack of ROW_NUMBER() in SQL Server 2000. This means you'll either have to take your chance with IDENTITY, at the risk...

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

    November 27, 2008 at 11:00 am

    #904435

  • RE: can i improve performance in this query

    Peso (11/27/2008)

    The query returns 290 columns and joins 62 tables. Under these cirumstances I think 7 seconds is quite good.

    Ditto.

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

    November 27, 2008 at 10:30 am

    #904424

  • RE: Knowledge sharing

    Mannie, thanks for posting the article... your points are well taken and the appearance of the article is actually very timely for me. It gave me a chance 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)

    November 27, 2008 at 10:27 am

    #904423

  • RE: Knowledge sharing

    David Burrows (11/27/2008)

    And Jeff makes a good point too. Not enough of you guys get credit for posting knowledge...

    Hear, hear. 🙂

    But I think we all owe thanks to folks...

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

    November 27, 2008 at 10:20 am

    #904418

  • RE: Knowledge sharing

    thisisfutile (11/25/2008)

    Jeff Moden (11/25/2008)

    ...

    Heh... then there's the "intelligent" ones that say things like "performance" doesn't matter and will argue for hours about it. The only reason why I continue...

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

    November 27, 2008 at 10:17 am

    #904416

  • RE: Knowledge sharing

    G Bryant McClellan (11/25/2008)

    Manie makes some very good points. I wish SQLServerCentral had been around in 1994 when I started working with SQL Server.

    And Jeff makes a good point too....

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

    November 27, 2008 at 9:49 am

    #904407

  • RE: Are the posted questions getting worse?

    Matt Miller (11/26/2008)

    ...and - we're doing it again. By virtue of this thread alone - we're HIGHLIGHTING the "ugly threads" which mean they get more facetime, and (probably) more...

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

    November 26, 2008 at 10:43 pm

    #904139

Viewing 15 posts - 46,981 through 46,995 (of 59,095 total)