when I run this example below it work. but when I apply my case it didn't work

so I don't know when is wrong

USE AdventureWorks2008R2;

GO

CREATE TABLE Production.UpdatedInventory

...

I want to insert the output from merge statement to another table.