John


Its making sense after the fourth reading <vbg>

I think part of the problem was that I've just downloaded the Android SDK and Eclipse. Its a long time ago that I started with Delphi but I'm sure it wasn't as bad as this!

Roy Lambert

John:

Thanks, the "soft join" with the month-numbers table that you are suggesting is brilliant & I can see how that will work immediately.

Some of the rest of it will require some time to figure out ... thanks!

I'm guessing you might be the type to have Jim Celko's SQL for Smarties as bed-time reading.

Roy,

<< The fundamental question is why you're restricting yourself to SQL? >>

This is what I was thinking of with my suggestion (script/procedure):

http://www.elevatesoft.com/articles?action=view&category=edb&article=cross_tab_result_sets_elevatedb_scripts

SQL cursors in a script/procedure will be a lot easier to manage for
something like this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< The fundamental question is why you're restricting yourself to SQL? >>
>
>This is what I was thinking of with my suggestion (script/procedure):
>
>http://www.elevatesoft.com/articles?action=view&category=edb&article=cross_tab_result_sets_elevatedb_scripts
>
>SQL cursors in a script/procedure will be a lot easier to manage for
>something like this.

Interesting. I was actually thinking Delphi but your's is a nice approach.

Roy Lambert