• I only modified this to use the prefix "PEC_" rather than sp_, and my table is PEC_edi_834

    The proc gets created with no error, but when I try to run the proc, I get:

    Msg 156, Level 15, State 1, Procedure PEC_pec_edi_834_insert, Line 1

    Incorrect syntax near the keyword 'BEGIN'.

    Msg 137, Level 15, State 2, Procedure PEC_pec_edi_834_insert, Line 1

    Must declare the scalar variable "@Payer_ID_Code".

    Msg 137, Level 15, State 2, Procedure PEC_pec_edi_834_update, Line 1

    Must declare the scalar variable "@Payer_ID_Code".

    Procedure [dbo].[PEC_pec_edi_834_delete] Created Successfully

    Any ideas?

    Thanks.

    *******************
    What I lack in youth, I make up for in immaturity!