>>Hey all, >> >>I have a query that needs running totals by the SomeId and month. I think SQL Server complicates the matter and I might not be able to do it. The query is like this: >> >>Select SomeID, Month , *Running Total Here* >>From ( Some really crazy complicated query ) CrazyQuery >>Order by SomeId, Month >> >>This seems like it should be fairly simple but from what I understand, I'm going to have to create another crazyquery and reference the dates.. Am I incorrect about this? >> >>Thanks, >>Dan > >Please read a newly published article http://www.sqlservercentral.com/articles/T-SQL/68467/
And actually, see these articles by Itzik Ben-Gan (only the first one is free):