If I have multiple result sets which are created from within the same Editor window, is there a quick way to find the statement which generated a particular result set?
Suppose I have a long query and I’ve placed several Select statements through it for troubleshooting. Consider the following very simple example.
Select * From INFORMATION_SCHEMA.COLUMNS
/*
Blah Blah Blah
/
Select * From INFORMATION_SCHEMA.TABLES
/
Blah Blah Blah
*/
Select * From INFORMATION_SCHEMA.KEY_COLUMN_USAGE
Now suppose that instead of the bogus comments I had large sections of code? This produces several result sets which I can switch between in the Results pane. However, if I want to go to the query which produced the 2nd result set, I have to manually look for it. Is there some faster way, perhaps by double clicking or right cliking in the Results pane to automatically jump to it within the editor?