Unfortunately I have no SQL Server installed in home to test this only VFP but I think It has't be much differt.
Because I am not a very familiar with SQL Server SQL Sintaxe i suppose that SELECT clause supports INTO...
so

SELECT COUNT(*), SUM..... INTO Query1
SELECT .....              INTO Query2

SELECT Query1.*, Query2.* FROM Query1, Query2

must gives You the result You want