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!