This part

"SUM OVER" & "ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW"

Thanks!

yb751 (1/21/2016)

At least you provided the sample data which is more than some. 😉

Good to know...

I'm trying to, but it would help If you could provide a brief explanation.

Thanks much!

Thank you yb751!

The real data has dates, but I wanted to simplify it.

Thank you!

Thank you J Livingston SQL! It worked.

Thanks you Luis C and Micky! Both the solutions worked like charm.

Hi, Thanks for the reply.

Sorry, forgot to mention, there is a seq number.

CREATE TABLE #xy123

(

tktamt MONEY,

...

Thanks for the reply Abu Dina and Ed Wagner!

We have SQL sever 2000 database, I am not sure If I can use this in SQL server 2000?

Thanks!

Okay Lynn Pettis, Actually I want to code for the 'O' part of the case statement and populate a flag, that is the reason, I was trying to re-write it...

Yes Lynn Pettis.

Thanks for the reply Lynn Pettis.

There are two records with a value of '1' for column c1, t1 value for those records is null where as t2 has values as...

ColdCoffee (7/17/2012)

ssc_san (7/17/2012)

ColdCoffee (7/17/2012)

Meaning, 0,9,13,14,16 will...

ColdCoffee (7/17/2012)

Meaning, 0,9,13,14,16 will have other...

Thanks for the query Coldcoffee.

We have a issue here, they may add other adjustment periods in the future, so it is not a fixed set of periods.

Any other method...

Try this:

DECLARE @testagg TABLE

(

id VARCHAR(10),

nm VARCHAR(20),

amt INT...