Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Show results based on String Search RE: Show results based on String Search

  • February 17, 2018 at 4:14 pm

    #1980186

    shyamhr - Saturday, February 17, 2018 2:26 PM

    Thanks Jeff for the idea. I actually implemented the same idea you said. I penned down all the stuff in the papers. I got the same idea so now I pick the AgencyNo list from CompanionAgencyNo look up table and match it with input parameter and pick the rows from the source table for those AgencyNo.

    What would be better is to brow beat the designers of these tables into submission to have them actually required the Companion Agency data to be present before it's allowed to appear in the Parent/Child list.

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