Запрос на 5 минут

USE RS_DWH;
GO
declare @enddate int;
SET @enddate = (SELECT top 1 dbo.Date_Dim.ID FROM dbo.Date_Dim WHERE dbo.Date_Dim.DateOper = '2013-06-27');
declare @startdate int;
SET @startdate = (SELECT top 1 dbo.Date_Dim.ID FROM dbo.Date_Dim WHERE dbo.Date_Dim.DateOper = '2013-05-27');
declare @days int = @enddate - @startdate;
       SELECT top 1 dbo.StrOut_Fact.KEY_TO AS 'Torgovyj Object',
       SUM(dbo.StrOut_Fact.SumRozn) AS 'Vyruchka',
       SUM(dbo.StrOut_Fact.SumRozn - dbo.StrOut_Fact.SumOpt) AS 'Pribyl',
       SUM(dbo.StrOut_Fact.SumRozn - dbo.StrOut_Fact.SumOpt)/SUM(dbo.StrOut_Fact.SumRozn)*100 AS 'Marga',
       SUM(dbo.StrOut_Fact.SumRozn - dbo.StrOut_Fact.SumOpt)/SUM(dbo.StrOut_Fact.SumOpt)*100 AS 'Nacenky',
       COUNT(dbo.StrOut_Fact.SumRozn) AS 'Kolychestvo chekov',
       COUNT(dbo.StrOut_Fact.SumRozn)/@days AS 'Kol. chekov v denj',
       COUNT(dbo.StrOut_Fact.SumRozn)/SUM(dbo.StrOut_Fact.SumRozn) AS 'Sum of chek'
       FROM dbo.StrOut_Fact
       left join dbo.TO_Dim ON dbo.StrOut_Fact.KEY_TO = dbo.TO_Dim.ID
       left join dbo.StrRstDay_Fact ON dbo.TO_Dim.ID=dbo.StrRstDay_Fact.KEY_TO
       join dbo.Cll_Dim ON dbo.TO_Dim.KEY_Cll = dbo.Cll_Dim.ID
       left join dbo.Date_Dim ON dbo.StrOut_Fact.KEY_Date = dbo.Date_Dim.ID
       WHERE dbo.Date_Dim.ID BETWEEN @startdate AND @enddate GROUP BY dbo.StrOut_Fact.KEY_TO;
GO