how to create query based on optional field on temp table ?

problem

I work on sql server 2012

I have temp table #tempsupplier have two fields

SupplierId mandatory have value

TradeCode optinal have value may be have or may be not have value

so i need

if(tradecode have value then execute)
do specific select
select p.PartID, p.PartNumber,m.SupplierId,m.TradeCode from #tempsupplier m
inner join #parts p on p.SupplierId=m.SupplierId
where not exists ( select 1 from #TradeCodes t where t.TradeCode=m.TradeCode)
if (tradecode not have value meaning is null then execute depend on supplier only)
select p.PartID, p.PartNumber,m.SupplierId,m.TradeCode from #tempsupplier m
inner join #parts p on p.SupplierId=m.SupplierId
where not exists ( select 1 from #TradeCodes t where t.PartID=p.PartID )

1 Reply

Know the answer? Post it — somebody with the same question will find it here.