I'm trying to implement a stored procedure like this where it's going to compare UserID from another table. If that user id already exists in dbo.user info table, it will insert data into [dbo].[BulkUploadTagDetail] table.
Every time I execute this stored procedure running into an issue that the data doesn't get inserted into my database table.
CREATE PROCEDURE [dbo].[InsertBulkUploadTagDetail]
(@BulkTagID INT,
@PortalUserID UNIQUEIDENTIFIER,
@EmailAddress VARCHAR(256),
@BulkUploadFileName VARCHAR(256),
@CreatedOn DATETIME2(7),
@IsCompleted BIT = 0)
AS
BEGIN
SET NOCOUNT ON
IF EXISTS (SELECT UserID
FROM dbo.UserInfo
WHERE UserID = @PortalUserID)
BEGIN
UPDATE [unp]
SET [unp].[BulkTagID] = @BulkTagID,
[unp].[UserID] = @PortalUserID,
[unp].[EmailAddress] = @EmailAddress,
[unp].[BulkUploadFileName] = @BulkUploadFileName,
[unp].[CreatedOn] = GETUTCDATE(),
[unp].[IsCompleted] = @IsCompleted
FROM
[dbo].[InsertBulkUploadTagDetail] unp
INNER JOIN
[dbo].[UserInfo] uinfo ON [unp].[UserID] = [uinfo].[UserID]
WHERE
[unp].[UserID] = @PortalUserID
END
ELSE
BEGIN
INSERT INTO [dbo].[BulkUploadTagDetail]
([BulkTagID], [PortalUserID], [EmailAddress],
[BulkUploadFileName], [CreatedOn], [IsCompleted])
VALUES (@BulkTagID, @PortalUserID, @EmailAddress,
@BulkUploadFileName, @CreatedOn, @IsCompleted)
END
END