Is there a way to scroll multiple query results simutaneously. I ran two separate queries for the same table in different databases and would like to scroll on one result and have it move the second grid at the same time.
asked
Scrolling Query results
You could join the results together.
Put a row_number on each side and do a full join on those fields.
Or copy the data out to Excel?
Excel is a good idea. At least you can put the stuff side-by-side pretty quickly.
If I understand what you're looking for, no, there's no way to do that within Management Studio. There might be using one of the third party apps.
As Grant says, there isnt any way in SSMS, try SQL Data Compare from RedGate though, you can get a 14 day trial from here: http://www.red-gate.com/products/SQL_Data_Compare/index.htm I use it quite often and it does a good job. It goes well with their SQL Compare product that is a database object comparison product.
[Edit] Just thought of another way: If budget is tight and you are able to export the data to some text format (csv, txt, xls etc) then you could use Winmerge, its a neat little app that compares files and/or folders in windows file systems. A useful tool to have close by even if its not your solution this time.
+ 1 Yeah, or one of the standard text editors that have all those funky functions might do the same thing.
