Hi,

I'm looking for a SQL 2005 query to do a running sum to do this:
I want to identify the first day when an employee reached 20% of absences.

I have 2 table:
Absences (by activity, day, employee...)
Activities (duration in days...)

so when an employee in 1 activity reached 20% of time lost I want the day
when this event appears.

I want an SQL 2005 version. does the new features in 2005 can provides good
results quickly?

also I have AS2005 cubes based on these tables.
I have tried MDX formula, but its too slow to be effective, so I'll preload
my cube from a view.
but maybe you have a magic MDX formula ;-)

the destination cube for this cumul will allow the user to know which
activity, who and when an employee reached the threshold value, also the
frequency etc...

thanks for your feedback.

Jerome.

Unfortunately there isn't any way to do this in SQL 2005.
There have been some posts recently on how to do this.
http://www.sqljunkies.com/WebLog/sim...ggregates.aspx

MDX should provide a quick answer but I'm not an MDX person sorry

--
Simon Sabin
SQL Server MVP
http://sqljunkies.com/weblog/simons

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote