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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.