Composed before I read Steve Jones post ....
Sorry about that Steve I should have hit the refresh before hitting post.
Scott Coleman
How on earth can you claim "no changes" is an action that was executed?
Cliff Jones
Yes, please explain the difference between answers 1 and 2 because it is very subtle
The action that was executed by the merge statement was the comparison between all the data in the table depts and all the data in table delta to determine if additional further action was required.
The objective of the QOD as I understand it is to get people thinking and learning. And the subtle actions of the merge is that all the rows in both tables are examined.
Scott Coleman
I'm really getting tired of questions that play word games
Scott Coleman - how about you submitting a QOD. It is quite a challenge.
Edited at 11:20 AM