• P.S. That table has a fair number of columns that you might want to add indexes to. With that thought in mind, I strongly recommend that you do a "vertical" partition on the table where that nasty MemberPhoto column and a duplication of the MemberID column are made to reside in a separate table. Consider adding a "Date_Added" column to that "sister" table, as well, to support possible partitioning efforts in the future to reduce the huge load on backups and possible restores that table will represent in the future.

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