I work on SQL server 2012 I have issue I can't get Part Id that have only map from and not have map to
depend on table #map ?
every part id must be found on table trades two times
first row for same part for map from
second row for same part for map to
meaning every part must exist two time
but if it exist as one time for part as map from and not have map to
what I need to display because it not have map to
as example parts 1410,1445 have map from only so it must display
part 1348 no need to display or show because it have map from and map to
so How to write query on sql server 2012 display parts from table trades that have map from only and not have map to depend on table #map ?
create table #trades ( PartId int, CodeTypeId int, Code int, PartLevel int ) insert into #trades(PartId,CodeTypeId,Code,PartLevel) values (1348,9090,13456,0), (1348,7070,13000,1), (1387,9090,13456,0), (1387,7070,13000,1), (1390,9090,13456,0), (1390,7070,13000,1), (1800,9095,13570,0), (1800,7075,14000,1), (1850,9095,13570,0), (1850,7075,14000,1), (1400,9090,13456,0), (1410,9090,13456,0), (1445,9095,13570,0), (1485,9095,13570,0) create table #map ( MapId int, CodeTypeFrom int, CodeTypeTo int, CodeValueFrom int, CodeValueTo int ) insert into #map(MapId,CodeTypeFrom,CodeTypeTo,CodeValueFrom,CodeValueTo) values (3030,9090,7070,13456,13000), (3035,9095,7075,13570,14000)
PartId CodeTypeId Code PartLevel 1400 9090 13456 0 1410 9090 13456 0 1445 9095 13570 0 1485 9095 13570 0