Forum Replies Created

Viewing 15 posts - 35,371 through 35,385 (of 59,102 total)

  • RE: Cross join query help

    joshtheflame (1/15/2011)

    Lutz and Jeff,

    I have only date datatype not time as I dont need time stored in table. Although i always find a problem regarding date formats. I want 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)

    January 15, 2011 at 2:37 pm

    #1273941

  • RE: Please help with SQL code

    LutzM (1/15/2011)

    The sample data can be found here (it's the Edit: 11th post of this thread).

    Heh... I know that, Lutz. 🙂 I was suggesting that the OP repost the...

    --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 15, 2011 at 2:33 pm

    #1273940

  • RE: Upper/lower case text

    Ok... if I had to write such a thing today, here's how I'd probably write it... it's pretty fast, too, although I'm sure someone will come up with a way...

    --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 14, 2011 at 9:46 pm

    #1273872

  • RE: Upper/lower case text

    mister.magoo (1/14/2011)

    Jeff Moden (1/14/2011)

    Lowell (1/4/2011)

    this is the ProperCase function I use; it's from a post by Jeff Moden, i believe, harvested long long ago.

    This may be the source....

    http://www.sqlservercentral.com/Forums/FindPost644446.aspx

    Thanks, Magoo...

    That's 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)

    January 14, 2011 at 8:56 pm

    #1273870

  • RE: Upper/lower case text

    Jeff Moden (1/14/2011)

    Wow! I just took a closer look at the code above. If I actually was the one who wrote that, I'm awfully sorry. :sick: ...

    --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 14, 2011 at 8:45 pm

    #1273869

  • RE: Upper/lower case text

    Lowell (1/4/2011)

    this is the ProperCase function I use; it's from a post by Jeff Moden, i believe, harvested long long ago.

    you can search for "ProperCase" or "InitCaps" here on SSC...

    --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 14, 2011 at 7:00 pm

    #1273862

  • RE: Upper/lower case text

    mister.magoo (1/4/2011)

    As you only have three small strings to make initial caps I would personally stick with your first thought....

    UPDATE dbo.wce_contact

    SET

    firstname= STUFF (lower (firstname), 1, 1, UPPER...

    --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 14, 2011 at 6:31 pm

    #1273859

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (1/14/2011)

    Roy Ernest (1/14/2011)

    Jeff Moden (1/13/2011)

    Roy Ernest (1/13/2011)

    This place rocks... I ask for help and I get tons of help. This is the second time I asked for help...

    --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 14, 2011 at 6:26 pm

    #1273858

  • RE: Proc Performance

    TheSQLGuru (1/14/2011)

    I have gotten 5 orders of magnitude performance improvement by using...

    I absolutely agree that properly written dynamic SQL can beat the tar out of most "catch all" code as...

    --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 14, 2011 at 6:18 pm

    #1273857

  • RE: Please help with SQL code

    pwalter83 (1/14/2011)

    Hi Jeff,

    Here is the updated scenario:

    If POL_COUNTRY_CD or POD_COUNTRY_CD in NCV_BL_DHL_TEMP table begins with FR, then use POL_Location_CD / POD_Location_CD and join to MG_LOCATION table to identify continent. If...

    --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 14, 2011 at 6:13 pm

    #1273856

  • RE: Are the posted questions getting worse?

    LutzM (1/14/2011)

    Jeff Moden (1/13/2011)

    LutzM (1/13/2011)

    Any of the Threadizens interested in a performance tuning project in the Los Angeles area? Drop me a PM.

    I don't suppose there's a chance of doing...

    --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 14, 2011 at 6:01 pm

    #1273855

  • RE: Merge performance on Very Large Tables

    I'n not sure why but I get an error on the execution plan you attached after saving it and trying to open it. Since you're also using MERGE 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 14, 2011 at 5:56 pm

    #1273854

  • RE: UPDATE using a self-join

    CELKO (1/14/2011)

    Since there is a move among MVPs to deprecate this in favor of MERGE and no other product uses it, I would clean up my code and get with...

    --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 14, 2011 at 5:52 pm

    #1273853

  • RE: RETURN clause, clarification

    You bet... thanks for the feedback.

    --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 14, 2011 at 4:51 pm

    #1273849

  • RE: Update query nightmare!

    christopher.hawkes (1/14/2011)

    Thanks for the reply,

    Yep i've tried that and i get the same result, its almost like ignores the previous row as its just been updated?

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

    January 14, 2011 at 3:09 pm

    #1273827

Viewing 15 posts - 35,371 through 35,385 (of 59,102 total)