>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
Define your output table the same or similar as your source and target and explicitly list columns in the OUTPUT clause, don't use *
If it's not broken, fix it until it is.
My Blog