How to delete from table in case code type have value or not

How to delete from table in case of code type have value ?

I have temp table #temppc

I need when codetype on temp table #tempPc not have null meaning have value

then

delete statement from table Parts.TradeCodes will be

DELETE TCC FROM #TempPC t INNER JOIN Parts.TradeCodes TCC ON t.ZPLID=TCC.ZPLID and t.CodeType=TCC.codeType

and if codetype on temp table #TempPc is null then delete statment from table Parts.TradeCodes will not have codetype

and it will be

so How to modify delete statment on query below that to delete based on two cases if codetype have value or not

2 Replies

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

Ashutosh Gupta6y ago
you can try to use "Is Null" and "Is Not Null" for t.CodeType
you can add where statement saying that where t.CodeType Is null
0
Suraj Kumar6y ago
It will be better and easy to help you if you provide the sample data and the expected output both in the expected format also schema of all the included tables.
0