Summing result od date arithmatic?

Hello:

One of my business analysts wants to write a query to select the difference, in days between two days, and sum each difference for each row so that he can see 5 sums for example,one for each row, as it is selected in the result set?

For example:\

columna ,columnb ,5(days), 5(cumulative sum) columna, columnb, 6(days), 11(cumulative sum columa, columnb, 3(days), 14(cumulative sum)........

 Is this possible? Or can there only be a sum at the end using a compute?

Thanks.

David Spaisman Received on Tue Nov 03 1998 - 11:54:29 CST