UPDATE  RC_Teammates
SET     ntid = @ntid,
        departmentID = @departmentID,
        role = @role
WHERE   ntid = @ntid

BEGIN

    SET NOCOUNT ON;

    BEGIN TRANSACTION;

        BEGIN
            INSERT INTO RC_PermissionsUsers
            (
                            ntid,
                            departmentID,
                            [role]
            )
            SELECT          ParamValues.ntid.value('.', 'varchar(255)'),
                            @departmentID,
                            @role
            FROM            @xmlUsers.nodes('/users/ntid') AS ParamValues(ntid)
            WHERE NOT EXISTS
            (
                SELECT      ntid
                FROM        RC_PermissionsUsers
                WHERE       ntid = ParamValues.ntid.value('.', 'varchar(255)')
            )

        END

    COMMIT TRANSACTION;
END