combine multiple small queries into one single query
SELECT 1 as Combo, GoalQuadrantCd as name, GoalTypeCd as code, SomeDescription as label
FROM Table1
Union All
SELECT 2 as Combo, SourceSystemId as name, SubCd as code, HierarchyName as label
FROM Table2 where SourceSystemId='YX'