RE: SQL and a Running/Moving Total

["Tom" <tomh@xxxxxxxxxxx>]

+1 funny

Tom H


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of iseries@xxxxxxxxxxxx
Sent: Thursday, October 08, 2009 3:06 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL and a Running/Moving Total

> Table has 3 columns,Name,year,count  and I need a total of the "count"
> field
> for each name over a 3 yr period, if there are NOT 3 years available
> then no
> output row.

Project approved.  Please proceed.

<snip>
--
"When a man says he approves of something in principle, it means he hasn't
the slightest intention of putting it into practice."