SELECT
(Select SUM (ISNULL(Amount,0)) From blah1.dbo.Paymenthistory
where Billdesc like '%Blah Blah%'
and Receivedate >= '6/30/2012 00:00:00'
and Receivedate < '6/30/2012 23:59:59')
+
(Select SUM ((ISNULL(Amount,0)) From blah2.dbo.Paymenthistory
where Billdesc like '%Blah Blah%'
and Receivedate >= '6/30/2012 00:00:00'
and Receivedate < '6/30/2012 23:59:59')
AS "Blah + Blah"
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events