Jeff,

absolutely brilliant!

I have been using a different method for some time to do this - but yours is simpler and blistering fast!

Well done and thank you.

JJ

Mike, Peso,

really big thank you guys! Both of your answers worked - but in slightly different ways.

I ran both against my data (1,126,066 records) and the results were as follows:

Peso...

Michael,

thanks for that..... but it still wants me to put the column 'Date' in the group by statement.

If I use 'convert(varchar(10),Date,120)' in the select statement I don't get the...