check out connectionstrings.com

I would avoid the loop, create a temp table named #temp and insert the values of the Years from 2000 to 2010.

I would then do your insert like this:

Insert Into...