Forum Replies Created

Viewing 15 posts - 38,506 through 38,520 (of 59,072 total)

  • RE: CTE performance

    Almost there... just another 10 or so minutes...

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

    May 9, 2010 at 7:26 pm

    #1164765

  • RE: CTE performance

    Sorry... our posts overlapped... I'll take a look.

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

    May 9, 2010 at 7:19 pm

    #1164764

  • RE: CTE performance

    Correction... it's splitting at the period properly but because of the exact duplication of the 3 rows, it's not returning the correct levels. What do you want to do...

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

    May 9, 2010 at 7:18 pm

    #1164763

  • RE: CTE performance

    kazim.raza (5/9/2010)

    these EntityIDs have different Types with them, say Jeff Mordan is Moderator of this site but at the same time he's an author as well.

    Did you have 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)

    May 9, 2010 at 7:08 pm

    #1164760

  • RE: CTE performance

    Sure... I'll take a look at it. What do you mean by "fix" 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)

    May 9, 2010 at 7:00 pm

    #1164758

  • RE: CTE performance

    kazim.raza (5/9/2010)

    OrgEntityID has to be unique by all means, can you please tell me the ID that's occurring more than once?

    Thanks,

    Kazim Raza

    There are 2554 in the text file you attached....

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

    May 9, 2010 at 6:46 pm

    #1164756

  • RE: CTE performance

    Heh... there's a fly in the ointment, Kazim. I thought that OrgEntityID was supposed to be unique according to the configuration of your CTE. The data you gave...

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

    May 9, 2010 at 6:31 pm

    #1164751

  • RE: CTE performance

    kazim.raza (5/9/2010)

    Um.. I am trying to get those but my staging server is offline right now; I'll make an attempt again. B/w you want those 161 K rows with proper...

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

    May 9, 2010 at 6:18 pm

    #1164747

  • RE: CTE performance

    kazim.raza (5/9/2010)

    I am considering to loop through all the rows...

    Heh... now them's fightin' words, Kazim. 😛

    Not to worry... this is easy now that I know what needs to be done....

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

    May 9, 2010 at 5:44 pm

    #1164743

  • RE: SQL Server Aggregation Query - Help needed

    ColdCoffee (5/7/2010)

    Nagesh S-432384 (5/7/2010)

    I am sorry ColdCoffee I pointed my reply to Jeff whereas you are the one who wrote the code... I started participating on this forum frequently which...

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

    May 9, 2010 at 5:32 pm

    #1164741

  • RE: Good Enough

    wldhrs (5/6/2010)

    Edited ... oops curly { on a url doesn't make it look like a url 🙁

    Jeff, you're sounding (reading?) almost as jaded as I am.

    Heh... if you mean tired...

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

    May 9, 2010 at 5:21 pm

    #1164740

  • RE: CTE performance

    kazim.raza (5/9/2010)

    This query is part of an ETL process where I am extracting the data out of the transactional database and inserting them into the data mart where our architect...

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

    May 9, 2010 at 4:58 pm

    #1164736

  • RE: CTE performance

    kazim.raza (5/9/2010)

    Jeff, assume those numbers are name; you may replace them with some alphabets. I have used the numbers instead of the original data to avoid propriety issues; and probably...

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

    May 9, 2010 at 1:50 pm

    #1164722

  • RE: Using " IN " inside " WHERE " clause

    Heh... don't ya just love it when the OP doesn't even show up for 24 hours? 😉

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

    May 9, 2010 at 1:41 pm

    #1164720

  • RE: query to get a part of strin

    Lynn Pettis (5/8/2010)

    The lesson here was not requirements, but what the OP has done to solve the problem presented. I asked this as this post is similar, yet different,...

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

    May 9, 2010 at 9:56 am

    #1164710

Viewing 15 posts - 38,506 through 38,520 (of 59,072 total)