Forum Replies Created

Viewing 15 posts - 38,791 through 38,805 (of 59,072 total)

  • RE: Pivoting name value pairs

    COldCoffee (4/20/2010)

    Jeff, you really are a wonderful character.. and for paul and karthik, thanks for providing new views and test results.. u guys are simply great.. thanks all 🙂

    Shucks. :blush:...

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

    April 20, 2010 at 8:46 pm

    #1155064

  • RE: Pivoting name value pairs

    Paul White NZ (4/20/2010)

    pYak (4/20/2010)

    are there any particular cases that you can think of where using the PIVOT operator would be more appropriate?

    Not really, no. The PIVOT is shorthand...

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

    April 20, 2010 at 8:41 pm

    #1155058

  • RE: Select a string when data in the string varies

    Bill,

    Yeah, at this point, we need some more information. Please post the code for the split function you're actually using so we can check it for errors, 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)

    April 20, 2010 at 8:25 pm

    #1155055

  • RE: MCJ - The Missing Link

    dma-669038 (4/20/2010)

    I also suggest we keep the 'journeyman' and replace 'Microsoft Certified' with something else...like a 'SQL Server Journeyman' perhaps..one of the comments i got on the survey was 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)

    April 20, 2010 at 2:32 pm

    #1154944

  • RE: Are the posted questions getting worse?

    Tom.Thomson (4/20/2010)

    Gianluca Sartori (4/20/2010)

    Tom, just out of curiosity, what does your signature mean? I think it's Scot-Gaelic and you look very Scottish (my Scottish uncle could be your lost twin...).

    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)

    April 20, 2010 at 9:54 am

    #1154716

  • RE: MCJ - The Missing Link

    CirquedeSQLeil (4/19/2010)

    WayneS (4/19/2010)

    Jeff Moden (4/19/2010)

    Good. Because of my inherent distrust in all the other certifications, I'd like to see this one materialize provided that less fortunate folks can actually...

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

    April 20, 2010 at 7:30 am

    #1154564

  • RE: Pivoting name value pairs

    pYak (4/20/2010)

    I agree with Paul its all about trying different solutions for the same problem.

    Absolutely true. "A Developer must not guess... A Developer must KNOW." 😀 That's why...

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

    April 20, 2010 at 7:24 am

    #1154554

  • RE: Pivoting name value pairs

    karthikeyan-444867 (4/20/2010)

    here are the results from my PC.

    ********** COldCoffee's Concatenate and Split solution **********

    SQL Server Execution Times:

    CPU time = 0 ms, elapsed time = 0 ms.

    SQL...

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

    April 20, 2010 at 7:12 am

    #1154542

  • RE: SQL Server Ranking Functions

    Yowch... the formatting monster hit the code hard on this one. I hope Steve can fix it soon.

    Glad to see you in the saddle again, Wayne. ...

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

    April 19, 2010 at 11:24 pm

    #1154311

  • RE: Performance Issue

    gagandeep.singh (4/19/2010)

    Is there a better way to write the following query in terms of performance without adding any indexes?

    SELECT T.amount, R.RATE, T.amount * R.RATE AS AMOUNT_CA, trade_date, FWR_DATE, trade_ccy, CCY...

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

    April 19, 2010 at 11:12 pm

    #1154305

  • RE: How to add add columns in a SP and reference them in the same SP?

    It could be done with a little dynamic SQL provided that either the dynamic SQL was protected from SQL Injection or simply had nothing to do with any external parameters.

    But,...

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

    April 19, 2010 at 11:04 pm

    #1154302

  • RE: convert whole no. to float

    The Dixie Flatline (4/19/2010)

    Try this:

    Avg(1.0*pat_count)

    Or just Avg(0.0+pat_count) which is just a little less expensive CPU wise.

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

    April 19, 2010 at 11:00 pm

    #1154300

  • RE: No One is Safe

    Heh... can you imagine? Someone calls at 2:00AM with a prank call to ask "Is your refrigerator running?" and when you go to look, the damned thing has taken...

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

    April 19, 2010 at 10:57 pm

    #1154298

  • RE: Are the posted questions getting worse?

    Lynn Pettis (4/19/2010)

    I would still like to know which question you were refering to initially.

    Yep... me too. If anyone knows the URL, please post it... it appears there may...

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

    April 19, 2010 at 10:44 pm

    #1154292

  • RE: Are the posted questions getting worse?

    Trey Staker (4/19/2010)

    This thread is a little different than most the threads on this site. It takes a while to really understand it for what it is. 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)

    April 19, 2010 at 10:42 pm

    #1154290

Viewing 15 posts - 38,791 through 38,805 (of 59,072 total)