nafasak
پنج شنبه 15 دی 1390, 10:17 صبح
سلام،
این ویو از روی یک ویو دیگه ست، میشه اینو بهینه کرد؟ آخه timeout دارم....
SELECT (SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain
WHERE (CostItem = 10) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F10C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 12) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F12C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 14) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F14C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 15) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F15C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 17) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F17C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 20) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F20C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 22) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F22C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 24) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F24C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem IN (25, 27)) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F25C,
(SELECT ISNULL(SUM(Ampunt) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 29) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F29C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 42) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F42C, ProductID, ProductName, ProductGrID, ProductGrName,
CityID, CityName, StateID, StateName, QuestDate
FROM dbo.Vw_PCAJ_CostReportMain AS CRPMain
GROUP BY ProductID, ProductName, ProductGrID, ProductGrName, CityID, CityName, StateID, StateName, QuestDate
این ویو از روی یک ویو دیگه ست، میشه اینو بهینه کرد؟ آخه timeout دارم....
SELECT (SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain
WHERE (CostItem = 10) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F10C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 12) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F12C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 14) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F14C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 15) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F15C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 17) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F17C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 20) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F20C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 22) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F22C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 24) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F24C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem IN (25, 27)) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F25C,
(SELECT ISNULL(SUM(Ampunt) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 29) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F29C,
(SELECT ISNULL(SUM(Cost) / NULLIF (dbo.GetSumSps(CRPMain.ProductID, CRPMain.CityID), 0), 0) AS Expr1
FROM dbo.Vw_PCAJ_CostReportMain AS View_1_2
WHERE (CostItem = 42) AND (CRPMain.ProductID = ProductID) AND (CRPMain.CityID = CityID)) AS F42C, ProductID, ProductName, ProductGrID, ProductGrName,
CityID, CityName, StateID, StateName, QuestDate
FROM dbo.Vw_PCAJ_CostReportMain AS CRPMain
GROUP BY ProductID, ProductName, ProductGrID, ProductGrName, CityID, CityName, StateID, StateName, QuestDate