Thanks that sorted it.

Such a simple problem and I could not see it for the want of looking.

Thanks again.

Cheers for this, works a treat.

Thanks for your replies.

The amount needs to be dived over the months and your right some invoices will span over part months like (01/15/2010 - 06/01/2010).

So for example an invoice...

OK the following script will create a cut down version of the table in question. If you need the whole table then let me know but I am only...

Thanks for quick response. I will have a look at the articles and your code and see what I can achieve.

Cheers for the replys, i'll take a look at them.

One last thing - can anyone suggest any good resources to help me learn TSQL?