|
|
Posted by Greg D. Moore \(Strider\) on 04/15/06 02:15
<sucaba.r@gmail.com> wrote in message
news:1145023509.190804.201060@g10g2000cwb.googlegroups.com...
> I've got a table that contains a column of accumulating uptime data
> that looks similar to this:
>
> 239.13
> 239.21
> 239.30
> 239.38
> 239.46
> 239.55
> 0.35
> 0.44
> 0.53
> 0.60
> 0.68
> 0.78
> 0.85
> 0.93
As others have suggested, DDL will help.
However, based on what I just saw for row_numbers in SQL 2005, this may be a
great application for their use.
So, what version of SQL are you running?
>
> I need to SUM the data up the point where the data gets reset (the next
> row is less than the preceeding row). Then I start the SUM again until
> data gets reset.
>
> Thanks in advance for help!
>
Navigation:
[Reply to this message]
|