How to update check exist column by value 1 where partid exist on table FeaturesvalueA or FeaturesvalueB ?
I work on sql server 2012 I face issue I need to update column checkexist on table temp
where partid exist at least one time on table #FeaturesvalueA or table #FeaturesvalueB
But if partid exist on both tables then not update check exist by 1
i need only update check exist by 1 in case of exist on only one table from both
FeaturesvalueA or FeaturesvalueB
case of not update
IF partid exist on both tables #FeaturesvalueA and #FeaturesvalueB then no need to update column check exist by 1
IF partid not exist on both tables #FeaturesvalueA and #FeaturesvalueB then no need to update column check exist by 1
case of update