Associate all users of a type to a specific Group

Version 2
    Question

    To associate all users of a given type to a Group

    Answer

    see attached stored procedure which contains instructions

    Please do not undertake this on a live system before a successful trial on a test environment.

    Always take a full database backup before running stored procedures on a live environment.

    Environment

    ITBM all versions