[SOLVED] How can I query the results of a query in Server Explorer in Visual Studio?

How can I query the results of a query in Server Explorer in Visual Studio?

I can get the results of a Stored Proc from Visual Studio by following these steps:

0) Select View > Server Explorer

1) Locate the Data Connection that contains the SP of interest.

2) Right-click the SP and select Execute; if any args are required, it will allow you to populate those in a dialog and then proceed with the execution

Provided that you have provided valid args (and the SP returns data), the results will display in a grid in a T-SQL Results tab.

Now, though, what if you want to query that "dataset" that has been returned, such as to sum the values of a particular column - can that be done right there from within Visual Studio.Server Explorer.T-SQL? If so, how?

UPDATE

I believe Khazratbek, but I can only get this far in a New Query instantiated by right-clicking the Tables folder beneath the Data Connection:

SELECT SUM(QtyShipped), SUM(QtyOrdered) FROM CPSData.

...the options available as a drop down following that final "." do not contain the results of the Stored Proc (SQLQuery1.sql).

Is it really possible?

Solution

Server Explorer -. Right click on Tables -> New query. Write your query (you may select from your SP execution results) and just click on triangle sign. Sorry, if I misunderstand your exact question.