;
        merge into dbo.REF_**** gu
          using (
                select *
                  from ##tmp_Users tmp
                 where tmp.user_id  is not null
                   and tmp.group_id is not null
                )
                tmp
                on gu.user_id = tmp.user_id
               and gu.group_id = tmp.group_id
        when not matched then
        insert(    group_id,     user_id)
        values(tmp.group_id, tmp.user_id)
        ;



сообщение: 2627, уровень: 14, состояние: 1, процедура: dbo., строка: 193 [строка начала па-кета: 0]
Violation of UNIQUE KEY constraint 'UK_REF_****'. Cannot insert duplicate key in object 'dbo.REF_****'.
 The duplicate key value is (21033, 19714).
The statement has been terminated.




ALTER TABLE [dbo].[REF_**** ADD  CONSTRAINT [UK_REF_****] UNIQUE NONCLUSTERED 
(
	[Group_id] ASC,
	[User_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

        merge into dbo.REF_**** gu
          using (
                select 35 group_id, 1101 user_id union all
                select 35 group_id, 1101 user_id
                )
                tmp
                on gu.user_id = tmp.user_id
               and gu.group_id = tmp.group_id
        when not matched then
        insert(    group_id,     user_id)
        values(tmp.group_id, tmp.user_id)
        ;