I work on SQL server 2012 I face issue I can't display maskes that have multiple id different on same mask and on same time
every part have pinout different from another part related to same mask then display it .
meaning mask like 1200 below have multi part id and different and pin out as 10 and 5 for parts related to same mask then display or show it .
so I get first masked have multiple part
then check parts inside mask is similar or different
if different then check pin out if is different then display it .
create table #parts
insert into #parts(MaskId,PartId,PinOut)
Expected result is
sample to explain
3 masked report must display as 1200 and 1900 and 4500
i show only above 1200 for explain and clear only