Running total help

[deeya]

Hello all,

CR10 SQL SERVER.

I have two groups Server Name and Trenddatetime.

What i want to do is calculate the change in diskspace day by day result will be the third column. Now the hard part: The next thing I want to do is calculate how long it will take by average(result) for the memory to run out. i.e disk space will run out 28/12/2007.

172.20.4.99 result
21/12/2006 219,386 80
20/12/2006 219,466 93
19/12/2006 219,559 83
18/12/2006 219,642 0

Thanks in advance.

 

[Madawc]

Divide remaining disk-space by days. Call that @DaysLeft

Now add this to the current date, Currentdate + @DaysLeft.

For more complex adds, DateAdd can be used, but a simple addition to the current date is assumed to be whole days.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[deeya]

sorry you missed the part of the third column how do i calculate that?