Your insert statements don't run...
Msg 109, Level 15, State 1, Line 54
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
It would be helpful if you would edit your post with the data, and surround the code with the [ code = "sql" ] and [ / code ] tags (I added extra spaces so that they will show up in the post; you need to remove them).
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes