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: