Hi

If I use a SQL Merge with an Output Clause, If I dont specify an INTO, it works fine
However, If I use an INTO clause , it errors with a 'Column Name or number of supplied values does not match table...

I cant seem to get the Column Names correct in the output table

1. Does it matter what they are called
2. Do they have to be same as source
3. Do they have to be same as source with an old_ and a new_ prefixed
4. Does the Type matter

I just cannot seem to get the column names correct

Tia
Gerard