Umbraco: Add a NEW member group to all members who do not have the group already assigned

UpdateAllMembersWithNewMemberGroup.sql

-- Variables --
DECLARE @memberGroup VARCHAR(100) = 'PORTAL MEMBER'
DECLARE @memberGroupIntId INT
DECLARE @nodeId INT


-- Get the INT ID of the member group that is called 'Portal Member' --
SELECT @memberGroupIntId = [id] 
    FROM [dbo].[umbracoNode] 
    WHERE nodeObjectType = '366E63B9-880F-4E13-A61C-98069B029728'  -- This GUID is for member groups --
    AND UPPER(Text) = UPPER(@memberGroup)
				
-- Add all members not in the group, to the group
INSERT INTO [cmsMember2MemberGroup] ([Member], [MemberGroup]) 
    SELECT [NodeId],@memberGroupIntId 
    FROM [cmsMember] 
    WHERE nodeId NOT IN (
        SELECT [Member] 
        FROM [cmsMember2MemberGroup] 
        WHERE [MemberGroup] = @memberGroupIntId)