>>I issued the following:-
>>
>>insert into yearly1 select * from yearly
>>
>>I get the following message:-
>>Msg 8101, Level 16, State 1, Line 1
>>An explicit value for the identity column in table 'yearly1' can only be specified when a column list is used and IDENTITY_INSERT is ON.
>>
>>SET IDENTITY_INSERT yearly1 OFF
>>insert into yearly1 select * from yearly
>>
>>The following message apper:-
>>
>>Msg 8101, Level 16, State 1, Line 3
>>An explicit value for the identity column in table 'yearly1' can only be specified when a column list is used and IDENTITY_INSERT is ON.
>
>When dealing with identity columns, SQL requires that you specify all of the column names in the insert statement..
>
>insert into yearly1 (columnname1,columnname2,...) select columnname1, columnname2,... from yearly

If you do not need to explicitly insert your identity column value (not sure in this case) just make sure you skip the identity column in your column lists and let SQL Server create identity values.