Thanks, you have explained some good basics for me to think about...too bad it's not offered in Standard.

However, how do schema changes on the tblEmployee table impact the...

Added some changes..fixed schema syntax, used quotename, changed code to use union all with SELECTs

DECLARE @TABLE_NAME sysname, @TABLE_SCHEMA sysname

SELECT @TABLE_SCHEMA='dbo'

SELECT @TABLE_NAME='Media'

SET NOCOUNT ON

DECLARE @CMD nvarchar(max)

DECLARE @INSCMD nvarchar(max)

DECLARE @INSVAL varchar(max)

DECLARE