CREATE PROCEDURE FAQ_Answer
(
	@UniqueID	bigint,
	@ReplyUserID	bigint,
	@Answer	text,
	@Question	varchar(1024) = null,
	@Status	smallint ,
	@CategoryID	int,
	@Published	tinyint,
	@Title		varchar(128)
)
AS
/* Update answer */
IF EXISTS(Select QuestionID FROM FAQAnswers Where QuestionID=@UniqueID)
	/* Not existing yet so add it */
	BEGIN
		INSERT INTO FAQAnswers
		(
			QuestionID,
			ReplyUserID,
			AnsweredOn,
			Answer,
			LastEdited,
			EditedBy
		)
		VALUES
		(
			@UniqueID,
			@ReplyUserID,
			getdate(),
			@Answer,
			getdate(),
			@ReplyUserID
		);
	END
ELSE
	BEGIN
		/* Exists So update */
		UPDATE FAQAnswers
		SET
			LastEdited=getdate(),
			EditedBy = @ReplyUserID,
			Answer=COALESCE(@Answer,Answer)
		WHERE QuestionID = @UniqueID;
	END
/* update question */

UPDATE FAQQuestions
SET
	Question=COALESCE(@Question,Question),
	Status=@Status,
	CategoryID=@CategoryID,
	Published=@Published,
	Title=COALESCE(@Title,Title)
WHERE UniqueID=@UniqueID

GO