-- Insert statements for procedure here

INSERT INTO People
(FirstName,LastName,MiddleInitial,Prefix,Suffix,Birthdate,Gender,SSN,Websit eURL,Email1,Email2,EMail3)
OUTPUT INSERTED.PersonID INTO @TempPersonID VALUES
(@FirstName,@LastName,@MiddleInitial,@Prefix,@Suffix,@Birthdate,@Gender,@SS N,@WebsiteURL,@Email1,@EMail2,@EMail3)

I just want to get the unique identifier back (sql 2005) its a
newsquentialid() default value being created... I want to push its value
back to a parameter after creation of the record... when I do this one and
try to save it into a sproc it says

Msg 1087, Level 15, State 2, Procedure PEOPLE_CreatePerson, Line 30

Must declare the table variable "@TempPersonID".

thanks!

Try something like this:

DECLARE @TempPersonID uniqueidentifier
DECLARE @Temp TABLE (PersonID uniqueidentifier)

INSERT INTO People
(FirstName,LastName,MiddleInitial,Prefix,Suffix,Birthdate,Gender,SSN,Websit eURL,Email1,Email2,EMail3)
OUTPUT INSERTED.PersonID INTO @Temp VALUES
(@FirstName,@LastName,@MiddleInitial,@Prefix,@Suffix,@Birthdate,@Gender,@SS N,@WebsiteURL,@Email1,@EMail2,@EMail3)

SELECT @TempPersonID=PersonID FROM @Temp

Razvan

-----------------------------------------------Reply-----------------------------------------------