Dan,
The code you have posted is for two queries -- not two stored procedures.
Sorry if I'm not really clear.
Unfortunately, your question is not clear (to me, at least).
I suggest you supply an example of the data in the "dbo.Table" database table,
and the desired output from your "combined" query. Then I might understand
what you mean by:
How to exactly combine the two stored procedures
Good Luck,
Avi.