leesider (11/26/2012)
I am going to need a cursor, I just don't know how to detect when a year or month datepart changes from date to date.
No cursor required.
Try this: -
SELECT [YEAR] = YEAR(startup_Time),
[MONTH_NUMBER] = DENSE_RANK() OVER(ORDER BY DATEADD(MONTH, DATEDIFF(MONTH, 0, startup_Time), 0)),
startup_Time
FROM #KWHtemp;