I think your best bet is not to worry about how many rows you have and just worry about the running total.

create table #t

(Name Varchar(20),

Salary Money)

insert into #t values ('John',...

Wait a second. Is there a reason this data can't be a datatype of datetime?

I have found that this is the fastest way to strip off time, and yet...