Forum Replies Created

Viewing 15 posts - 43,471 through 43,485 (of 59,063 total)

  • RE: Week numbers and week start dates

    balars_2000 (6/9/2009)

    hi mate

    thanks for ur response; appreciate it.

    sorry if i wasnt clear, i need week numbers and week start dates for any given date range or a year. if 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)

    June 9, 2009 at 8:56 pm

    #1007165

  • RE: O(n) , O(n log n), O(n^2)

    O(wtf2) 😉

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

    June 9, 2009 at 7:26 pm

    #1007149

  • RE: What is the equivalent to Yes/No data type in SQL?

    With that thought in mind, even the BIT datatype is tri-state... Yes, No, an dunno (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)

    June 9, 2009 at 7:20 pm

    #1007147

  • RE: charindex help

    hugh.mileshkin (6/9/2009)

    Thanks so much for your help Jeff & John, really appreciate it! 🙂

    Thanks, Hugh. Good feedback like that is the only pay we get for this type 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)

    June 9, 2009 at 7:17 pm

    #1007145

  • RE: Forums on your Resume/CV

    GilaMonster (6/9/2009)

    He turned it down, because his current company had offered him a raise if he would stay.

    Yowch! I have some pretty strong feelings about that. I...

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

    June 9, 2009 at 7:12 pm

    #1007143

  • RE: Forums on your Resume/CV

    jcrawf02 (6/9/2009)

    Let the record state officially that I have never observed RBarryYoung to in any way condone inappropriate behavior of this sort, and that my post relating to his unfortunate...

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

    June 9, 2009 at 7:09 pm

    #1007142

  • RE: Random problems

    Mike C (6/9/2009)

    drogers (6/9/2009)

    A minor quibble with the article: the problem is not that RAND() is called multiple times with the same seed, once per row. The problem is 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)

    June 9, 2009 at 7:02 pm

    #1007141

  • RE: Random problems

    drogers (6/9/2009)

    Jeff Moden (6/9/2009)

    RAND() in T-SQL works exactly the same way as RAND() in any computer language.... one row or value at a time.

    No, it doesn't work at all like...

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

    June 9, 2009 at 6:59 pm

    #1007139

  • RE: Random problems

    Heh... in that case, no. NEWID() is random enough as a seed.

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

    June 9, 2009 at 12:18 pm

    #1006982

  • RE: Are the posted questions getting worse?

    GilaMonster (6/9/2009)

    Gee Barry

    RBarryYoung (6/9/2009) Big-O notation categorizes an algorithm's complexity in terms of the dominant term (without any constant factors) of its execution run-time as a function of the length...

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

    June 9, 2009 at 12:16 pm

    #1006981

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)

    Jeff Moden (6/9/2009)

    Lynn Pettis (6/9/2009)

    Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

    Which tread?...

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

    June 9, 2009 at 12:11 pm

    #1006978

  • RE: Random problems

    Mike C (6/9/2009)

    Someguy (6/9/2009)

    OK. I'll be the one to ask the dumb question:

    Most languages have a random function that does not require you to add seeds and/or do other things...

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

    June 9, 2009 at 12:07 pm

    #1006974

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/9/2009)

    Okay, I must be in pissy mood today and I have NO idea why. I just lmgtfy twice in the same thread...

    Which tread? I must bear...

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

    June 9, 2009 at 10:29 am

    #1006853

  • RE: Random problems

    vzurkowski (6/9/2009)

    Exactly!

    NEWID() creates a unique identifier.

    Is it randomly distributed over as set of charater strings of certain length, or something like that? Otherwise, it is not clear RAND(checksum(newid())) is unformly...

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

    June 9, 2009 at 9:55 am

    #1006827

  • RE: Random problems

    Heh... nope... formatting not fixed. The code window removed blank lines and when you copy from the code window and paste into SSMS using IE, all the leading spaces...

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

    June 9, 2009 at 9:47 am

    #1006816

Viewing 15 posts - 43,471 through 43,485 (of 59,063 total)