leesider (11/27/2012)

---

OK, as I said in my last post I need to extend it a little further to include a running total. Cadavre is correct, I don't need a cursor. I need to execute an inner select from another table that also contains a startup_Time. I want to compare this startup_Time with the startup_Time in the outer select and as it goes from one week to the next, select from the column KWH_savings and add it up for each week in the inner select.

What I have below does it except it is too slow:

;with cte as

(

SELECT [YEAR] = YEAR(st.startup_Time),

DATEPART(ww, st.startup_Time) as WeekNumber,

(

SELECT SUM(st2.KWH_savings)

FROM #KWHtemp st2

WHERE

st2.startup_Time <= st.startup_Time

) AS AccountRunningTotal

FROM #KWHtemp st

)

SELECT *

FROM cte

It is the inner select that is slowing it down, I don't know if I can do it a different way that is not so slow.