So like this? Sorry I have not used SET Command before. I'm pretty new to SQL. This didnt work in this format, but I think it is wrong the way I set it up. It says:
Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'ON'.
Msg 156, Level 15, State 1, Line 65
Incorrect syntax near the keyword 'OFF'.
SET CONCAT_NULL_YIELDS_NULL {ON}
SELECT
(Select SUM (Amount) From Blah1.dbo.Paymenthistory)
+
(Select SUM (Amount) From Blah2.dbo.Paymenthistory)
As "Blah + Blah"
SET CONCAT_NULL_YIELDS_NULL {OFF}