Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Where IN @txtVariable (where txtVariable is a CSV list) RE: Where IN @txtVariable (where txtVariable is a CSV list)

  • August 19, 2015 at 11:52 pm

    #1821260

    Kevlarmpowered (8/19/2015)

    My DBAs frown on dynamic SQL...

    They REALLY need to get over that. Properly written dynamic SQL is SQL Injection proof, safe, fast, and will cache an execution plan just like any other SQL.

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