PERFECT! THANKS!

Just for reference here is what I ended up with.

USE [PlantSafety]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[spCopyVWI]

(

@JSAID int,

@NewPlant int

)

AS

SET NOCOUNT OFF;

INSERT INTO [JSA1] ( [DATE_TIME], [JSA], [JOBTITLE], [PPE], [NewOrRev],...

Yes please.

This is why I have so far

USE [PlantSafety]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[spCopyVWI]

(

@JSAID int,

@NewPlant int

)

AS

SET NOCOUNT OFF;

INSERT INTO [JSA1] ( [DATE_TIME], [JSA], [JOBTITLE], [PPE], [NewOrRev], [Company], [Plant], [nonRoutine],...