General information
Category:
Coding, syntax and commands
Title:
Sql Merge and Output command
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only