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