Highlight difference between selected rows
Time to time you need to compare data in the rows, for example when looking for the cause of duplication. If the query is complex enough with joins and wide tables I usually run
SELECT * FROM ...
and check where the duplication begins to easily find the root cause. The easiest way for me to do so is to copy it into the excel and do some simple formula to find the exact columns that have difference.
It would be nice if SQL Prompt would support that feature. If it's possible then it can be done by highlighting needed cells or columns and choosing the action from the right-click menu or maybe some script can be generated with the only columns where the values are different.
2
votes
Dmitrij Kultasev
shared this idea
-
Josh Hansen commented
This is such a great idea! I hope more people see this and vote it up.