I have a table called MyTable with the fields Id(int),Name(nvarchar),Value1(bit),Value2(bit)
EX:

```
1   Nathan  True    False
2   Nathan  True    False
3   John    True    False
4   John    False   True

```

So i can easily find the duplicates by name like this:

```
select 'First_Id'=a.Id,'First_Value1'=a.Value1,'First_Value2'=a.Value2, 
        'Second_Id'=b.Id,'Second_Value1'=b.Value1,'Second_Value2'=b.Value2
        from MyTable a, MyTable b where a.Id>b.Id
        and a.Name = b.Name

```

and then i can delete the ones with with the Id in the SecondId...

What i want to do is find the duplicates and do a logical OR between all the Value1 of the duplicate group and update every single record from the duplicates with that value and then the same thing for value2.

EX:

For the example above there will be 2 groups of duplicates

and the result will be:

```
1 Nathan True False
2 Nathan True False
3 John   True True
4 John   True True

```

How can i do that ?