I was confused when my answer was wrong, because the Field 1 is the 'column id' not 'object id'.

Hope to review the correct form on questions.

Thanks

This script is very useful when all the rows are not NULL, but if you modify the insert of Mark with NULL, the script only returns Bill.

insert into @table values...