SQl NOT IN

select partno,partid from dbo.parts where partno // wil come 1-1000 records
in
(
select partno from PriceExceptions where priceSchedule =@PriceSchedule // partno 1,2
)

SQL IN

select partno,partid from dbo.parts where partno // wil come 1-1000 records
in
(
select partno from PriceExceptions where priceSchedule =@PriceSchedule // partno 1,2
)