Thanks for your suggestions... Cheers

Thank you all, very informative and my load testing on this proc exhibited the correct mal-behaviours.  Appreciate everyone. Cheers.

ok, thanks, what you have there is stating that if the @parameter is null then i'm using the old column value instead, is that correct?

Thanks