Maybe you just want to do this?
SELECT * FROM (VALUES ((query 1), (query 2), (query 3), (query 4))) AS t(q1, q2, q3, q4);
If so, you can find more examples at Microsoft official documentation (
Table Value Constructor (Transact-SQL) - SQL Server | Microsoft Docs[
^]).
Or maybe just this?
query 1 UNION ALL query 2 UNION ALL query 3 UNION ALL query 4;
If so, you can find more examples at Microsoft official documentation (
UNION (Transact-SQL) - SQL Server | Microsoft Docs[
^]).
It depends on whether you want it vertically or horizontally. By the way, please make sure that your first query returns a scalar like all others.