I have a table of employee groups and user names
I query to get an updated list of groups that all users are in.
now I want to update my emp table to insert any new groups that the user is in and then a second query to delete any groups that they are no longer in.
I was thinking somthing like
insert into employeeGroups
select * from #tmpEmp where ()
but not sure how to exclude the rows that already exist