>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
Dan,
Can you please be more specific with your question? Do you need Running total algorithm - if yes, then search here, I posted good link before.
Here it is
http://www.sqlteam.com/article/calculating-running-totals
If it's not broken, fix it until it is.
My Blog