Hi, I am trying to write a query that will add sequentially. For
example,

Month    Week    Amount    Amount2
1    1    200    200
1    2    150    350
1    3    400    750

How do I get the Amount2 colmn which is really a running total to work
in sql.

Thanks

Challenging Query - Please Help
Convert *= / =* to outer joins (ANSI compliant)
SQL Include Empty Months
create a sp from query output
Combine records to calculate