INSERT INTO [dbo].[Governorate] ([MUD_ID], [MUD_NAME]) VALUES (@MUD_ID, @MUD_NAME) SELECT MUD_ID, MUD_NAME FROM dbo.Governorate