• You can get that specific count for your manager one of two ways. Safely:

    SELECT COUNT(*)

    FROM MyTable

    WHERE MyColumn = 'OldValue'

    Or not so safe:

    BEGIN TRAN

    UPDATE MyTable

    SET MyColumn = 'NewValue'

    WHERE MyColumn = 'OldValue'

    ROLLBACK TRAN

    The first query will return the count. The second query will return the number of rows affected, but it won't do anything. However, you are mucking with the data, just rolling it back, so you will put a load on the system. It's not as safe.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning