>>>What is native RI? You ignore it or set it. What does it matter if FK is null or empty when you're ignoring it. The only thing that matters is managing the nulls complexity.
>>>Cetin
>>
>>There is no complexity in handling NULLs. The FK can not be any value, it should be either the actual value from the list of existing codes in VisCodes or it could be NULL, which means that we don't have a code. Very simple rule and it works just fine.
>
>If you say so. Surrendered.
>Cetin
Good <g> The complexity is that we have to remember our rule and implement it on each insert/replace <g> And I just found we didn't follow our rule in LoadNewTrans. Anyway, I just told it to my manager and will give him the list of fields which are in Trans and not in Stage_Trans and we decide which fields we have to treat and how.
If it's not broken, fix it until it is.
My Blog