Forum Replies Created

Viewing 15 posts - 38,536 through 38,550 (of 59,098 total)

  • 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

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

    only4mithunc (5/9/2010)

    If it is hard coded, I'm thinking as below.

    SELECT *

    FROM InvoiceDetails

    WHERE InvoiceNo IN ('1248','1063','963','1524')

    ORDER BY CASE InvoiceNo

    WHEN '1248' THEN 1

    WHEN '1063' THEN 2

    WHEN...

    --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:20 am

    #1164707

  • RE: CTE performance

    Heh... Pity. I've got a million node solution for the MLM folks that absolutely rocks. Same goes for the creation of a million node "Nested Set" for "ad...

    --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:09 am

    #1164704

  • RE: Adding row and column totals to a dynamic pivot table

    Chris Lindley (5/8/2010)

    Ok, I understand your code. But it's not as simple as that. I can't just go creating a tally table in the DB as I don't own 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 8, 2010 at 8:34 pm

    #1164655

  • RE: Views

    satishthota (5/8/2010)

    Can you please give me examples on

    a) Non-Updateable Views

    b) Updateable Views

    Ummm... since I think this is a test question or maybe an interview question, I really need you 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)

    May 8, 2010 at 8:16 pm

    #1164653

Viewing 15 posts - 38,536 through 38,550 (of 59,098 total)