Forum Replies Created

Viewing 15 posts - 22,111 through 22,125 (of 59,072 total)

  • RE: Are the posted questions getting worse?

    TomThomson (12/28/2014)

    Jeff Moden (12/28/2014)

    TomThomson (12/28/2014)

    If I remember correctly it was adopted, in the same way as much other new new jargon was, ......

    How on Earth do you remember all this...

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

    December 28, 2014 at 2:07 pm

    #1766631

  • RE: NEED COLUMN NAMES FROM TABLE DYNAMICALLY

    Kannan Vignesh (12/28/2014)

    Hi Jeff,

    Thanks for your query. i changed the database name and table name but it returns nothing.

    That would be because I'm an idiot. :blush: I added 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)

    December 28, 2014 at 1:20 pm

    #1766628

  • RE: Faster way to populate number table variation with inline tally?

    Eirikur Eiriksson (12/27/2014)

    Run results

    OPERATION ...

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

    December 28, 2014 at 12:39 pm

    #1766624

  • RE: Faster way to populate number table variation with inline tally?

    sqldriver (12/27/2014)

    Holy cow. Those are both way prettier solutions. Thanks to both of you.

    I ran them on my test box and got close enough results.

    Jeff, first, you need 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)

    December 28, 2014 at 12:11 pm

    #1766622

  • RE: Faster way to populate number table variation with inline tally?

    Eirikur Eiriksson (12/27/2014)

    Just brilliant as always Jeff, Chapeau!

    Quick modification, mainly dropping the ISNULL as the set will not contain any nulls

    😎

    Thanks, Eirikur. You're the consummate Gentleman and I'm frequently...

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

    December 28, 2014 at 12:07 pm

    #1766620

  • RE: Are the posted questions getting worse?

    I use the terms "refactor" and "redact" as politically correct terms to explain what the effort will be when I'm going to fix some crap code. "Refactor" means 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)

    December 28, 2014 at 11:34 am

    #1766616

  • RE: Are the posted questions getting worse?

    TomThomson (12/28/2014)

    Stefan Krzywicki (12/22/2014)

    Steve Thompson-454462 (12/22/2014)

    Stefan Krzywicki (12/22/2014)

    When did we all start calling rewriting/reworking code "refactoring"?

    I'm using that term here to describe changes to a code base that affect/improve 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)

    December 28, 2014 at 11:30 am

    #1766615

  • RE: How to avoid Union/Union All?

    @Praxo,

    Man, I feel for you. Those are some pretty heavy restrictions and they're not unlike the restrictions one will find in SQL Server CE (Compact Edition). You covered...

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

    December 28, 2014 at 10:16 am

    #1766612

  • RE: How to avoid Union/Union All?

    Dave Ballantyne (12/28/2014)

    I dont understand why this cannot be a view ?

    If you can SELECT from a table you can SELECT from a view.

    Just make sure you ORDER BY on...

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

    December 28, 2014 at 10:10 am

    #1766611

  • RE: How to avoid Union/Union All?

    GilaMonster (12/28/2014)

    Jeff Moden (12/27/2014)

    It's actually difficult for me to believe that the front end can't produce or use a UNION ALL

    You'll probably find that the senior guru expert development lead...

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

    December 28, 2014 at 10:08 am

    #1766610

  • RE: Lists

    Hugo Kornelis (12/24/2014)

    DrKiller (12/23/2014)

    wow what a complex way of doing it.

    I'm usually just doing this 🙂

    DECLARE @tmpString VARCHAR(MAX)

    SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

    SELECT @tmpString

    Others...

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

    December 28, 2014 at 12:00 am

    #1766596

  • RE: Lists

    DrKiller (12/23/2014)

    wow what a complex way of doing it.

    I'm usually just doing this 🙂

    DECLARE @tmpString VARCHAR(MAX)

    SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

    SELECT @tmpString

    My only hang-up...

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

    December 27, 2014 at 11:52 pm

    #1766595

  • RE: Lists

    Guess I'll have to do my own testing because no one (unless I just missed it) has de-entitized the data in the XML method and the variable overlay method doesn'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)

    December 27, 2014 at 11:47 pm

    #1766594

  • RE: Lists

    Michael L John (12/23/2014)

    DrKiller (12/23/2014)

    wow what a complex way of doing it.

    I'm usually just doing this 🙂

    DECLARE @tmpString VARCHAR(MAX)

    SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

    SELECT...

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

    December 27, 2014 at 11:22 pm

    #1766591

  • RE: Faster way to populate number table variation with inline tally?

    @sqldriver,

    Apologies. Forgot to post the code to create the clustered index. SQL Server REALLY likes unique indexes and REALLY likes NOT NULL columns. With that 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)

    December 27, 2014 at 11:09 pm

    #1766590

Viewing 15 posts - 22,111 through 22,125 (of 59,072 total)