SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON
GO

CREATE Procedure up_new_profile
(
@member_id int,
@active bit,
@market varchar(50), ' Does this part of code values need to equal the exact code values in values section in code?
@salutation varchar(25),
@suffix varchar(25), ' @suffix varchar(25), and @suffix or can it equal @strsuf?
@snfname varchar(75),
@snlname varchar(75),
@profile_id int output
)
as
insert into profile(
member_id,
active,
market,
salutation,
suffix,
snfname,
snlname,
)
values(
@member_id,
@stractive
@strmakt ' Does this part of code values need to equal the exact code values in values section in code?
@strsal
@strsuf ' @suffix varchar(25), and @suffix or can it equal @strsuf?
@strsfn
@strsln
)

select @profile_id = @@identity
GO
SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON
GO

Thanks in advance