Assume I have these two queries in SQL Server 2014, both of which return one row from unrelated tables:
SELECT SUM(A) A, SUM(B) B FROM X SELECT SUM(C) C, SUM(D) D FROM Y
I'd like to combine these queries into a single resultset that contains
A, B, C, D.
What's a good way to do this within a single query, as opposed to multi-query solutions like selecting the results into and out of scalar variables?