Sean Lange (9/6/2013)

---

John.Hagen (9/6/2013)

---

Hi Everyone

I have a merge statement which ends with the following

WHEN NOT MATCHED BY SOURCE THEN

DELETE;

Now I need to record the deleted records in a table and I am having no luck getting the output to work. The records I need to record look like the following.

OID (int)

Version (int)

QK varchar(32)

GD varchar(32)

Geometry (Geometry)

and I would like to add a date column to record when the delete took place.

What do you mean that you are not having any luck getting output to work? I don't see OUTPUT in your query here at all. You can reference the deleted virtual table in a MERGE statement just like a trigger.