Create Procedure [dbo].[Check_IF_Person_Exist]
@FirstName nvarchar(50),
@LastName nvarchar (50),
@Guid nvarchar(50),
@intPersonID int OUTPUT
AS
BEGIN
IF EXISTS( SELECT ID FROM ITTESI_AssetTracker_Person WHERE Guid = @Guid)
BEGIN
SET @intPersonID = ( SELECT [ID] FROM ITTESI_AssetTracker_Person WHERE Guid = @Guid)
END
ELSE
BEGIN
INSERT INTO ITTESI_AssetTracker_Person VALUES (@Guid,@FirstName,@LastName)
SET @intPersonID = @@IDENTITY
END
END
Also thanks stogg