I have a project in SQL 2008 to take advantage of spatial data. All the rest of the projects are in SQL 2005.

Projects running on older version of SQL take time to upgrade to the next version of SQL but the ones developed from the scratch are more likely to be in latest SQL version.