oops!,my bad, am sorry.

Salesman Date Amount

A 5/1/2002 10000 **(Running total Equals 10000 which is limits table for A)

B 25/12/2002 8000

B 1/01/2003 7000**(Running Total equals 15000 which is...

Thanx Npeters, but am note getting my expected results. its giving me some inconsitent results.

to work with . herez ddl and dml operations.

create table Sales(salesman varchar(10),

date datetime,

amount decimal(9,2))

insert into Sales...