i am using a slowly changing dimension to update my table. but i need to incluse a few checks.
so after the table has been updated i am using another sp to do the checks.
what i need to do is, if the value in th ecode is NULL then use the previous code.
rowid datecreated validfrom validto iscurrent businesskey code recdel
1 18/09 18/09 17/09 0 C3 CW NO
2 18/09 18/09 NULL 1 C3 NULL NO