INSERT INTO [dbo].[test1] ([lattitude], [longitude], [heading], [desired_heading], [mot1_current], [mot2_current], [speed]) VALUES (@lattitude, @longitude, @heading, @desired_heading, @mot1_current, @mot2_current, @speed) SELECT time, lattitude, longitude, heading, desired_heading, mot1_current, mot2_current, speed FROM dbo.test1