• wrote:

    Jonathan AC Roberts wrote:

    I would use an SSMS add-in like ApexSQL Refactor.

    There is a free version of it here https://en.freedownloadmanager.org/Windows-PC/ApexSQL-Refactor-FREE.html

    I think you only get a trial period with the current version from the Apex site so better to use the download above.

    Or if you have a budget and don't mind paying for something I would get Redgate SQL Prompt.

    Thanks Man.

    Considering what even some "paid for" software does (like hiding malware they didn't know about), I'm mighty leery about downloading and installing just about anything anymore.  It's like playing volleyball in a mine field.

     

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