quote:

---

Originally posted by helixpoint

Not sure if you need more than this. The sql works when I run the query???

ERROR:
Msg 203, Level 16, State 2, Procedure InsertMember, Line 22
The name 'INSERT INTO member
(FirstName,lastName,txtEmail,EmailNewsletter,htmlYes)
VALUES ('George','Bush','lame@inwashington.com',1,1)' is not a valid identifier.






THE PROC:
ALTER PROCEDURE [dbo].[InsertMember]
(@dFields varchar(1000),
@dValues varchar(1000),
@id int OUTPUT)
AS

-- Create a variable @SQLStatement
DECLARE @SQLStatement varchar(1000)

-- Enter the dynamic SQL statement into the
-- variable @SQLStatement
SELECT @SQLStatement = 'INSERT INTO member
(' + @dFields + ')
VALUES (' + @dValues + ')'

-- Execute the SQL statement
EXEC (@SQLStatement)

Select @id = @@Identity

Dave
Helixpoint Web Development
http://www.helixpoint.com

---