I don't understand your query - would you mind adding some code you have so we can have a wee look at it? that would help tremendously.

Just based on what you wrote and me guessing what you are trying to achieve, you have the following:

Stored Procedure 1 calls Query 1

Stored Procedure 2 calls Query 2

You would like to have:

Stored Procedure 3 calling Query 1 and Query 2 and then combine (?) results.

You can call as many queries (SELECT statements) as you want in a SP - what you do with it is up to you, but - generally speaking - if you run a query and need the results of that query to be used further down the SP, then you would 'save' the results of the first query in a temp table or a table variable (or a "real" table) - and then use that as input for other queries.

Again, provide the code for your SPs (the relevant bits) and your query and spell out what you want to achieve (ie. how/why you want to combine the queries).

B