Jeff,

Thank you for the elegant solution I was after.

Intrigued, I added this code into a stored procedure and compared the performance against the existing, the average over 10 runs...

Hi Dwain,

Thanks for your reply, it's not quite what I'm after though.... Your solution appears to provide a count of the Tariffs for each Customer, I need to get a...

hi Rich,

Thank you for your reply! I was hoping this was going to be area where the phrase "It depends...." wouldn't appear, oh well!

select count(*) from table

and

select count(1) from table

will return the same results, but

select count(column name) from table

will return the number of non null columns

A reply from another old Developer....

Over the years SQL has expanded greatly, in the days of SQL 7 / 2000, the developers bible "Inside SQL" by Kalen Delaney was one...