Forum Replies Created

Viewing 15 posts - 45,421 through 45,435 (of 59,101 total)

  • RE: Calculating UnitPrice Discounts

    AFCC Inc. Com (1/29/2009)

    Thanks,

    Is the UnitPriceDiscount a percentage or a number ?

    select 10 *((1.0)-4)* 6

    or

    select 10 *((1.0)-.25)* 6

    Heh... you tell us... you're the one that can see the table....

    --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 29, 2009 at 10:53 pm

    #935295

  • RE: records with distinct IDs

    Tim Wilson-Brown (1/29/2009)

    Lowell (1/28/2009)

    in that case, it is impossible, unless you modify your table to include an identity column.

    Which is not reliable either - what if the identity values wrap?

    There...

    --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 29, 2009 at 10:17 pm

    #935283

  • RE: Calculating UnitPrice Discounts

    The 1.0 is to implicity force the calculation to a FLOAT datatype if everything turns out to be an INTEGER. The rest is a matter of simple substitution 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 29, 2009 at 10:11 pm

    #935282

  • RE: count of consecutive value

    I'll trade ya... 😉 Tell me the business reason behind this and I'll give you some code to do it. The reason for the "trade" is, I'm writting...

    --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 29, 2009 at 10:09 pm

    #935281

  • RE: performance issues

    I recently ran into a similar problem (this morning, in fact). The backups to disk had taken up all the harddrive space because they had a problem getting moved...

    --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 29, 2009 at 9:59 pm

    #935279

  • RE: Slack SQL Server

    Gift Peddie (1/29/2009)

    Oracle does not sell developer edition...

    Correct... instead, they give it away as a free download. 😉

    --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 29, 2009 at 9:52 pm

    #935277

  • RE: CLR Running in Mirrored Environment

    Jonathan Kehayias (1/28/2009)

    Does it really matter for the context of the question posed in this thread?

    Your aversion to CLR takes every thread in this forum completely off topic...

    --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 29, 2009 at 9:44 pm

    #935275

  • RE: Linking to the Previous Row

    David McKinney (1/25/2009)

    As Peter pointed out a few posts ago, a CTE is more akin to a subquery than a temp table, in that it is constructed when it 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 29, 2009 at 9:25 pm

    #935272

  • RE: Celebration

    Lynn Pettis (1/29/2009)

    Hmmm, so Cardinal Moden, a realist you are.

    Heh... nope... I saw that in the pork chop bones on my dinner plate. 😛

    --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 29, 2009 at 9:15 pm

    #935265

  • RE: Earning Credit

    Then, you've got some pretty good teachers. In a lot of places, either the teachers aren't so good as to hand out their personal contact numbers, or they don't...

    --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 29, 2009 at 9:06 pm

    #935258

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (1/29/2009)

    Jeff Moden (1/29/2009)

    would you post the URL for the thread you quoted me on, please?

    "The Post"

    [font="Verdana"]For the URL of the thread... just look up. Yep,...

    --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 29, 2009 at 9:00 pm

    #935256

  • RE: Get 2nd Occurence

    Trigger (1/29/2009)

    Well said Jeff!

    I will remember this saying!

    Heh... thanks Trigger... I've got a bunch more, but having been in the Navy, most of them aren't suitable to publish here. 😛

    --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 29, 2009 at 8:36 pm

    #935250

  • RE: Get 2nd Occurence

    smeet.sinha (1/28/2009)

    U r exceptional Jeff

    no more comments ........

    Thanks for the thoughtful comment, Smeet...

    By the way, did you ever find a work around concerning executing dynamic SQL in a function?

    --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 29, 2009 at 8:35 pm

    #935249

  • RE: What are the Party Plans?

    jgrubb (1/29/2009)

    Completely Off-Topic, I wanted to see who started the Pork Chop thing,

    Heh... do you really have to wonder? 😛

    --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 29, 2009 at 8:19 pm

    #935242

  • RE: Earning Credit

    While I absolutely agree that parents should be deeply involved in their kids schooling, not all parents can take the time off from work like you did, Lynn... especially 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)

    January 29, 2009 at 7:59 pm

    #935235

Viewing 15 posts - 45,421 through 45,435 (of 59,101 total)