SELECT (SELECTSUM(t.TepTotal)

FROM[RELET2007].[dbo].[RELETProjectsReports]r

INNERJOIN[RELET2007].[dbo].[RELETProjectsReportsTEP]tonr.RELETPRPID=t.RELETPRPID

  

Wherer.TEDACReceiveDate<'10-1-2014'

  

ANDr.AcceptedDate>='2-1-2015'

AND

r.AcceptedDate<'2-10-2015')'Backlog',

 

(SELECTSUM(t.TepTotal)

 

FROM[RELET2007].[dbo].[RELETProjectsReports]r

 

INNERJOIN[RELET2007].[dbo].[RELETProjectsReportsTEP]tonr.RELETPRPID=t.RELETPRPID

 

Wherer.TEDACReceiveDate>='10-1-2014'

 

ANDr.AcceptedDate>='2-1-2015'

AND

r.AcceptedDate<'2-10-2015')'REST OF WORLD';

• Moved by Simon_HouMicrosoft contingent staff, Moderator 4 hours 0 minutes ago right forum

Hi mkatyal,

For readability Iv format your query. The query looks good, what is your question then?

SELECT (
		SELECT SUM(t.TepTotal)
		FROM [RELET2007].[dbo].[RELETProjectsReports] r
		INNER JOIN [RELET2007].[dbo].[RELETProjectsReportsTEP] tonr.RELETPRPID = t.RELETPRPID
		WHERE r.TEDACReceiveDate < '10-1-2014' ANDr.AcceptedDate >= '2-1-2015'
			AND r.AcceptedDate < '2-10-2015'
		) 'Backlog'
	,(
		SELECT SUM(t.TepTotal)
		FROM [RELET2007].[dbo].[RELETProjectsReports] r
		INNER JOIN [RELET2007].[dbo].[RELETProjectsReportsTEP] tonr.RELETPRPID = t.RELETPRPID
		WHERE r.TEDACReceiveDate >= '10-1-2014' ANDr.AcceptedDate >= '2-1-2015'
			AND r.AcceptedDate < '2-10-2015'
		) 'REST OF WORLD';

You can avoid the subqueries and make it like this for simplicity

SELECT SUM(CASE WHEN r.TEDACReceiveDate < '10-1-2014' THEN t.TepTotal ELSE 0 END) AS [Backlog], 
SUM(CASE WHEN r.TEDACReceiveDate >= '10-1-2014' THEN t.TepTotal ELSE 0 END) AS [REST OF WORLD]
FROM [RELET2007].[dbo].[RELETProjectsReports] r
INNER JOIN [RELET2007].[dbo].[RELETProjectsReportsTEP] tonr ON tonr.RELETPRPID=t.RELETPRPID
Where r.AcceptedDate>='2-1-2015'
AND  r.AcceptedDate < '2-10-2015';