Forum Replies Created

Viewing 15 posts - 2,596 through 2,610 (of 59,098 total)

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

October 25, 2022 at 1:31 am

#4103949

  • Reply To: How to select parts that have messages based on feature id and feature value ?

    Just to be sure, what you're asking for is PartIDs that have the exact same FeatureID's and FeatureValue's as a given MessageID, correct?

     

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

    October 25, 2022 at 12:28 am

    #4103934

  • Reply To: Why does a select on 1 table end up putting locks on other tables?

    I guess maybe I'm the idiot.  I don't know extended events at all but I'm not seeing anything in that code that tells you those locks are from JUST 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)

    October 25, 2022 at 12:07 am

    #4103917

  • Reply To: combine values as pivot

    First, welcome aboard.  Just to help you on your postings, graphics are great for posting what you want to see or for additional explanations.  Most folks on this forum like...

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

    October 24, 2022 at 11:01 pm

    #4103859

  • Reply To: The Delete Order

    I had to give this one 5 stars because it's based on one of the basics in SQL Server, taught 35% of the people something, and there was no intentional...

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

    October 24, 2022 at 10:34 pm

    #4103837

  • Reply To: combine values as pivot

    Reminder... STRING_AGG() wasn't available until 2017.  The OP posted in a 2016 forum.

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

    October 24, 2022 at 7:21 pm

    #4103776

  • Reply To: Good Enough

    @WebRunner...

    And so there's yet another adage we can add...

    "If you want something real bad... that's usually the way you'll get 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)

    October 24, 2022 at 7:10 pm

    #4103769

  • Reply To: Good Enough

    The fly in the ointment is... what does "done" actually mean and when will it come back to bite you?  "Done" is just another name for "Good Enough" and I've...

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

    October 24, 2022 at 5:25 pm

    #4103733

  • Reply To: I need some urgent help!

    Yes... Steve Collins posted an example above.  You could also use multiple SELECTs with a UNION 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)

    October 24, 2022 at 2:44 pm

    #4103667

  • Reply To: Good Enough

    From the Article:

    I find that many of us that work in technology want a solution to be great. Often perfect. Computers are so good at following instructions...

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

    October 24, 2022 at 2:42 pm

    #4103666

  • Reply To: Why does a select on 1 table end up putting locks on other tables?

    Eirikur Eiriksson wrote:

    Yet again it would be helpful if we could see the actual execution plan! 😎

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

    October 24, 2022 at 1:26 pm

    #4103612

  • Reply To: I need some urgent help!

    mpate100 wrote:

    So I saw a while back that its possible with a case statement, because once this sql code is created it goes into a another software that parses basic...

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

    October 24, 2022 at 1:25 pm

    #4103611

  • Reply To: I need some urgent help!

    Ok... so what is "Criteria 1" and "Criteria 2" to return 1 value or another?

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

    October 22, 2022 at 9:37 pm

    #4103132

    • Viewing 15 posts - 2,596 through 2,610 (of 59,098 total)