CREATE PROCEDURE [dbo].[Members_Insert]
(
	@MemId uniqueidentifier = NEWID() OUTPUT,
	@Fname nvarchar(50) = NULL,
	@Lname nvarchar(50) = NULL,
	@Organization nvarchar(50) = NULL,
	@Address1 nvarchar(75) = NULL,
	@Address2 nvarchar(75) = NULL,
	@City nvarchar(50) = NULL,
	@State nvarchar(5) = NULL,
	@Country nvarchar(75) = NULL,
	@PostalCode nvarchar(15) = NULL,
	@Phone nvarchar(15) = NULL,
	@Fax nvarchar(15) = NULL,
	@Email nvarchar(50) = NULL,
	@TimeCreated smalldatetime,
	@LastUpdated smalldatetime = NULL,
	@IsActive bit = NULL
)
AS
	SET NOCOUNT ON

	INSERT INTO [Members]
	(
		[MemId],
		[Fname],
		[Lname],
		[Organization],
		[Address1],
		[Address2],
		[City],
		[State],
		[Country],
		[PostalCode],
		[Phone],
		[Fax],
		[Email],
		[TimeCreated],
		[LastUpdated],
		[IsActive]
	)
	VALUES
	(
		@MemId,
		@Fname,
		@Lname,
		@Organization,
		@Address1,
		@Address2,
		@City,
		@State,
		@Country,
		@PostalCode,
		@Phone,
		@Fax,
		@Email,
		@TimeCreated,
		@LastUpdated,
		@IsActive
	)

	RETURN @@Error

Msg 102, Level 15, State 1, Procedure Members_Insert, Line 3
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure Members_Insert, Line 45
Must declare the scalar variable "@Fname".