declare @temp table
insert into @temp values(1,10000)
insert into @temp values(1,10001)
insert into @temp values(2,10000)
the above insertion is valid but when i try to update the 2nd record
as id = 1 and code = 10000 it should not update since we have already an record inserted into table that is 1st record.
can one please help without using merge.