Forum Replies Created

Viewing 15 posts - 38,431 through 38,445 (of 59,098 total)

  • RE: SQL to manipulate rows of data

    krenshau (5/13/2010)

    Hello,

    I have a table that looks like this.

    projectId (char(15)) | departmentId (char(7)) | ...

    --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 13, 2010 at 11:48 am

    #1167098

  • RE: Monthly Data

    shjaffer (5/13/2010)

    It seems like I am not communicating my issue well.

    I wrote a sp with a while loop in it and I am getting what I want.

    Thanks

    SJ

    I'm trying to communicate...

    --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 13, 2010 at 11:37 am

    #1167092

  • RE: simple Insert - tune

    Hi Tara,

    There's simply not enough information in your post to really help. Take a look at the article at the second link in my signature line below. 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 13, 2010 at 7:51 am

    #1166875

  • RE: Help with re-writing a cursor to a set based solution

    Jim.A (5/12/2010)

    I apologize. I was trying to show 'real' code instead of a mock up so you could get an idea of the environment. Also the full function...

    --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 12, 2010 at 11:46 pm

    #1166645

  • RE: Five Things I Learned at the PASS Summit

    Very cool article, Steve. When you get that much brain-power, skill, and experience together all in one place, you can't help but learn something new and important even 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)

    May 12, 2010 at 11:04 pm

    #1166637

  • RE: Free Advice or Free Consulting

    Heh... Crap! This forum wouldn't let me give this article any more than 5 stars and it wouldn't let me vote more than once.

    On all fronts, well said, Grant.

    --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 12, 2010 at 10:52 pm

    #1166634

  • RE: High record/calculation query performance help

    bbeaumont (5/12/2010)

    Thank you for the response Jeff. Your reply along with the two linked posts in your signature set me on a path that helped me take the query from...

    --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 12, 2010 at 10:33 pm

    #1166630

  • RE: Code generation

    mister.magoo (5/12/2010)

    My 2p worth:

    Jeff has shown you a framework for generating numbers.

    I personally think you could consider generating more numbers and disallowing any with any repeating digits.

    You should 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 12, 2010 at 10:21 pm

    #1166626

  • RE: Monthly Data

    shjaffer (5/11/2010)

    I only added data for 2 months. If I could get the results like I want for the 2 months I will be happy.

    My issue is I don't...

    --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 12, 2010 at 10:13 pm

    #1166623

  • RE: Help with Query

    vijay.s (5/12/2010)

    Thankx for your post,

    I tried Quarily Update from My self and but i gets failed as I am not able to debug the problem.

    Still I want to know...

    --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 12, 2010 at 10:06 pm

    #1166619

  • RE: Help with Query

    elutin (5/12/2010)

    1. Quirky Update is very fast, but has some limitations and it is using undocumented feature of the SELECT. If you've read the article I've mentioned, you have seen...

    --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 12, 2010 at 10:04 pm

    #1166618

  • RE: Help with Query

    elutin (5/12/2010)

    "Quirky Update" way

    Here we are:

    1. I would not use it if I would be you.

    2. If you deside to use it, you must read

    "The RULES" section...

    --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 12, 2010 at 9:46 pm

    #1166612

  • RE: Code generation

    scziege (5/12/2010)

    Hey Jeff,

    our customer want to make a promotion on a product package with this codes.

    The customer can buy the product and insert the code onto a web page, after...

    --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 12, 2010 at 9:07 pm

    #1166605

  • RE: Do you know your getdate()?

    Joe Celko (5/12/2010)

    I just wish that Microsoft has used the ISO/ANSI Standard CURRENT_TIMESTAMP and CURRENT_DATE instead of more dialect. Of course, they are going to have trouble with TIMESTAMP(n) thanks...

    --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 12, 2010 at 3:55 pm

    #1166565

  • RE: checkning for allowable values

    Yes and no. You're certainly on the correct tract with making a table but it should be a permanent table instead of one built on the fly. Second,...

    --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 12, 2010 at 3:16 pm

    #1166553

Viewing 15 posts - 38,431 through 38,445 (of 59,098 total)