question

Richard Stoey avatar image
Richard Stoey asked

Scrolling Query results

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.

ssmsquery-results
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rob Farley avatar image
Rob Farley answered

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?

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Excel is a good idea. At least you can put the stuff side-by-side pretty quickly.
1 Like 1 ·
Grant Fritchey avatar image
Grant Fritchey answered

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.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thank you for your response I appreciate it.
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

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 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

+ 1 Yeah, or one of the standard text editors that have all those funky functions might do the same thing.
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.