I work on Sql server 2012 I face issue I can't update comment column for every part when part have more than one status distinct inside and outside as partid 1202 have multi status inside and outside
so i need to write query update comment where it have more than one status
distinct as part id 1202
but not update part id 1230 because it have two status outside but not
two status it is only one status but repeated