The original issue was whether stored procedures could handle complete "change tracking", which included the need to handle both explicit and implicit nulls. Statements were made about whether SPs were "flexible" enough to handle these types of situations. It's been demonstrated that they are. Case closed.