Taking more than 2 min T-SQL

Hi BandSr,

can you try declaring two variables outside your query? Something lke this:

DECLARE @StartDate DATETIME
DECLARE @EndDate   DATETIME

SET @StartDate = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) - 1, 0)
SET @EndDate   = DATEADD(dd, -1, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0))

SELECT DATEPART(YEAR, SaleDate) AS [PrevYear],
       DATENAME(MONTH, SaleDate) AS [PrevMonth],
       SaleDate as SaleDate,
       Sum(Amount) as PrevAmount
FROM TableA A
WHERE SaleDate >= @StartDate AND 
      SaleDate <= @EndDate
GROUP BY SaleDate

Hope this helps you

---

Emiliano Musso - MVP Visual Basic