hmmm... doesn't help me much though!

I've adapted the code from the link I posted.... 100,000 rows processed in 20 seconds for a moving average of 350 rows...

I may have found something interesting here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=93911

but yet to test...

Again, not sure that would work as I need every single row to have a different index...

row 351 has a average of rows 1 to 350

row 352 an average of...

Thanks for the idea, but that appears to average a single value, which gives the value, not an average of the previous 350 values... or am I missing something?