> One method I have read about ( in SQL for SMARTIES by Joe Celko) is to
> create an identity matrix for the months and then join that to the Sales
> table ( ItemsPermanent2).
>
> The matrix should look something like this:
> M Jan Feb Mar Apr ......
> 1 1 0 0 0
> 2 0 1 0 0
> 3 0 0 1 0
> 4 0 0 0 1

<=== snip ===============>

Very nice. Long weekend for me so I will try it first thing Tuesday morning,
bright and early :) Very shrewd way of tackling the problem though...I'm
look forward to timing it.

Thanks Andy,

Lee