Thx Lutz - that nails it!

Thanks Jeff!

Thanks Gift

I understand what a named instance is, but I'm not familiar with UAC and where/how to ensure that it's disabled.

One last thing...

I've just noticed that SS 2008 Developer Edition has ALL the functionality. Given that I'm building this for myself, and intend being the only user, this could work....

Thanks Steve. I guess I'll have to figure out how to do the mining with T-SQL and then look into using the reporting services to produce reports.

Wayne

Jeff is right. I have to cater for non-trading days other than weekends (which are not included in my sample data) so having a 7 day difference from the...

Many thanks Jeff, much appreciated.

I was hammering away with the row number function, but never got it to work successfully.

Wayne

I noticed this option, but figured that it would have global impact. It'd be great if there was a code option to discretionally suppress output within a SQL script/procedure.

Thx,

Wayne

Just within the SSMS session. Thx.

Many thanks Seth, much appreciated!

I'll be doing some reading on the running totals...

Wayne

Many thanks folks - that was enlightening.

Wayne

That did the trick.

The results are good, and needless to say, it performs way better than a cursor.

Thank you again,

Wayne

Many thanks guys. I was out for most of the day - will be testing it tomorrow.

Much appreciated,

Wayne

Hi folks

I guess I should have read those links first, it makes sense...

I'm deliberately using daily (fct.EOD) data as there are always "gaps" in the days, which is not the...

Hi folks

I've tried some some of the suggestions and although they compile, I do not obtain the desired results.

To better illustrate what I'm trying to do, here's a sample (using...