quote:

---

Originally posted by dwfresh

Hi guys
I am getting this pesky error and I don't know why.
Can someone tell me why I'm stuck. Im a newbie so please bear with me :)

Msg 206, Level 16, State 2, Procedure sp_User_Create, Line 21
Operand type clash: uniqueidentifier is incompatible with int


Here is the stored procedure I am trying to create.
I have a Users table. The 'UserId' column is the primary key (int), but I also have a 'Guid' column which is a uniqueidentifier.


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

CREATE PROCEDURE [dbo].[sp_User_Create]
(@FirstName nvarchar(50),
@LastName nvarchar(50),
@LoginName nvarchar(50),
@EgovUserProfileID int,
@EgovUserToken nvarchar(256),
@SecretQuestionId int,
@SecretAnswer nvarchar(256),
@MothersMaidenName nvarchar(50),
@Ssn nvarchar(9),
@UserId int OUTPUT,
@Guid uniqueidentifier OUTPUT)
AS


BEGIN
IF( @UserId IS NULL )
SELECT @UserId = NEWID()
ELSE
BEGIN
IF( EXISTS( SELECT UserId FROM dbo.Users
WHERE @UserId = UserId ) )
RETURN -1
END

INSERT into dbo.Users (FirstName, LastName, LoginName, Ssn, EgovUserProfileID, EgovUserToken, SecretQuestionId, SecretAnswer, MothersMaidenName, CreateDate, LastLoginDate, Guid)
VALUES (@FirstName, @LastName, LOWER(@LoginName), @Ssn, @EgovUserProfileID, @EgovUserToken, @SecretQuestionId, @SecretAnswer, @MothersMaidenName, GetDate(), Getdate(), newId())

RETURN 0
END

---