Forum Replies Created

Viewing 15 posts - 18,706 through 18,720 (of 59,098 total)

  • RE: Crosstab query NOT using pivot

    Exactly. Thanks for the early morning cover, Graham.

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

    January 8, 2016 at 5:12 am

    #1850466

  • RE: the use of CTEs

    erics44 (1/8/2016)

    ...and would that be considered daft use of a recursive CTE?

    Virtually any form of counting or other RBAR, even if it's for a low number of iterations. See...

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

    January 8, 2016 at 5:08 am

    #1850464

  • RE: Send email from T-SQL

    Again, sorry for the delay. I'd lost track of this particular thread.

    The code I spoke of is below. Look for the word "TODO" for changes that you'll need...

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

    January 7, 2016 at 11:01 pm

    #1850410

  • RE: Send email from T-SQL

    Rich Mechaber (1/7/2016)

    Hi, Jeff, we're all still waiting for this super-duper magical emailing code you allege to have concocted!

    :rolleyes:

    Rich

    First, thanks for responding. I had delete a whole bunch of...

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

    January 7, 2016 at 10:42 pm

    #1850408

  • RE: the use of CTEs

    Hugo Kornelis (1/6/2016)

    Oh, one more note. In between all the getting carried away with details and terminology and everyone being right and stuff, I forgot to add my two cents...

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

    January 7, 2016 at 9:49 pm

    #1850403

  • RE: the use of CTEs

    Alan.B (1/6/2016)

    You can't write a recursive CTE with using pre-CTE features.

    Technically correct because only an rCTE can be an rCTE but the rather well advertised rave in SQL Server...

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

    January 7, 2016 at 9:39 pm

    #1850402

  • RE: the use of CTEs

    Jason A. Long (1/7/2016)

    Jeff Moden (1/7/2016)

    Jason A. Long (12/24/2015)

    Unless you're using recursion, a CTE can be rewritten as a derived table... Considering that derived tables (and CTEs) are processed before...

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

    January 7, 2016 at 6:32 pm

    #1850394

  • RE: the use of CTEs

    Sergiy (1/7/2016)

    Jeff Moden (1/7/2016)

    That being said, let's please avoid a "Banker's Rounding" discussion on this thread. Thanks guys.

    Too late, mate.

    Sorry. 😛

    BWAAA-HAAA!!!! Only 300 or 400 more posts 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)

    January 7, 2016 at 6:25 pm

    #1850393

  • RE: Hacking to Hide

    Amazing. I think these things are a bit crazy, whether they be shipboard or on airplanes, considering the technology that's been available for a relatively long time now. ...

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

    January 7, 2016 at 5:27 pm

    #1850391

  • RE: Crosstab query NOT using pivot

    Tallboy (1/7/2016)

    Hi Folks;

    Jeffs code ran brilliantly until changed my test data and added two appointment rows for the same client with same date and times data but with different StaffID's.

    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)

    January 7, 2016 at 5:13 pm

    #1850388

  • RE: Row_number partition by specific range of numbers start with int and ends with char

    lsalih (1/6/2016)

    Perfect, it worked like a charm! Now I have one last question to ask: The ultimate goal is after we group the data is to extract each subset of...

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

    January 7, 2016 at 5:03 pm

    #1850387

  • RE: How to insert data from localdb to amazon redshift?

    [font="Arial Black"]{EDIT}[/font] I see that the WebMasters have restored the post I cited below. I left my original post, though.

    A member known as "SQL Daddy" posted a very...

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

    January 7, 2016 at 4:59 pm

    #1850386

  • RE: Creating Seperate Schema

    SQL!$@w$0ME (1/7/2016)

    Hello Guys,

    I'm in the process of initial design of a db and I'm new to this. Should I create separate schemas for db objects or I should keep all...

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

    January 7, 2016 at 4:52 pm

    #1850384

  • RE: Performance Baselining

    Heh... so far and without exception, I've found that the hardware is just fine. I have seen just twice where something went wrong (one was changing a router 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)

    January 7, 2016 at 4:16 pm

    #1850380

  • RE: Reorg index, rebuild index and reorg table

    ypeng5 (1/7/2016)

    so do I need to do table reorg? when do I need to table reorg?

    "It Depends" on a ton of things that are frequently not included in anyone's index...

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

    January 7, 2016 at 3:51 pm

    #1850374

Viewing 15 posts - 18,706 through 18,720 (of 59,098 total)