Well at least I know that I'm not crazy.  Guess I'm going to have to figure out another way to sort the problem with my SP.   Essentially the problem is this.  I have a driver proc which calls multiple other procs based on conditional logic.  All the procs work separately.   I know this because I've executed them separately successfully.  The logic in the driver looks correct and executes without any errors but does not produce the desired result.  The last leg of the driver proc executes a proc which basically does all my inserts and updates but when it's all said and done no new data is inserted into the database's two primary tables.  Transactions are being used but I have seen that the commit is being executed.  The only conclusion that I can reach is that my update proc never gets executed for some reason.