create your ID column as identity column : [FinancialContactID] int identity (1,1)
Then try something like this:INSERT INTO tblFinancialContact ([ProviderID],[FinancialContactPrefix],[FinancialContact],[FinancialPosition],[FinancialPhone],[FinancialExtension] ,[FinancialFax] ,[FinancialEmail] )SELECT [ProviderID],[FinancialContactPrefix],[FinancialContact],[FinancialPosition],[FinancialPhone],[FinancialExtension] ,[FinancialFax] ,[FinancialEmail]FROM tblServiceProvider