I found this but it does need seem to work when I run something similar for my needs in MSSQL 2000

> The SELECT command will return:

> 2002

> 2003

> 2004

> 2005

>

>...

Oh sorry - this is for 200,000 rows. This solution is interesting but would take too long. I was thinking along the pivot lines of SUM and CASE,...