its complaninig about the coloumn name that dont match in the insert statement:
Msg 207, Level 16, State 1, Line 1
which is not possible as the i am referencing the right table but i guess i am not too well versed with SQL. Maybe a temporary table will do? dont know.....