do you want to do it based on the values in column1 or based on the values in your groups table?

you could try a left join with an insert:

-- create tables

CREATE TABLE #Groups

(groups_pk1 INT)

CREATE TABLE #Ex

(column1 INT NOT NULL,

column2 VARCHAR(64) NOT NULL,

column3 INT IDENTITY(1, 1) NOT NULL)

-- populate preexisting sample...