My intent is not to drive people crazy with this. I'm sorry you feel that way, Scott.

My intent is to see if anyone has been able to...

Here is my pseudocode:

create PROCEDURE [dbo].[spUpdateTableA]

@TableAPK int, --only required parameter

@ColumnA nvarchar(50) = 'undefined',

@ColumnB int = -1

as

begin

SET NOCOUNT ON

SET XACT_ABORT ON

declare @ErrorMessage nvarchar(4000);

begin try

--Start the...

Unfortunately, I can't use look up tables because a default value for a parameter MUST be a constant, meaning either a literal value or a @@ constant. So, I'm...