Hi
Please refer below code
SQL
DECLARE @PersonTable AS TABLE(Id INT,Name VARCHAR(50))
INSERT INTO @PersonTable VALUES(1,'Nurullo')
INSERT INTO @PersonTable VALUES(2,'Firuz')
DECLARE @Product AS TABLE(Id INT,Name VARCHAR(50))
INSERT INTO @Product VALUES(1,'Fruits')
INSERT INTO @Product VALUES(2,'Vegetables')
DECLARE @ProductTable AS TABLE(Id INT IDENTITY(1,1),IdProduct INT,Name VARCHAR(50))
INSERT INTO @ProductTable VALUES(1,'Apple')
INSERT INTO @ProductTable VALUES(1,'Orange')
INSERT INTO @ProductTable VALUES(1,'Cherry')
INSERT INTO @ProductTable VALUES(1,'Melon')
INSERT INTO @ProductTable VALUES(2,'Tomato')
INSERT INTO @ProductTable VALUES(2,'Potato')
INSERT INTO @ProductTable VALUES(2,'Cucumber')
INSERT INTO @ProductTable VALUES(2,'onion')
DECLARE @SellerTable AS TABLE(Id INT IDENTITY(1,1),IdProduct INT,IdProductTable VARCHAR(50),IdPerson INT)
INSERT INTO @SellerTable VALUES(1,'1,2',1)
INSERT INTO @SellerTable VALUES(2,'3,4',2)
DECLARE @PersonId INT
DECLARE @ProductId INT
SET @PersonId = 1
SET @ProductId = 3
DECLARE @ProductCatId INT
SELECT @ProductCatId = IdProduct FROM @ProductTable WHERE Id = @ProductId
SELECT @ProductCatId
IF EXISTS(SELECT Id FROM @SellerTable WHERE IdPerson = @PersonId AND IdProduct = @ProductCatId)
BEGIN
UPDATE @SellerTable
SET IdProductTable = IdProductTable + ',' + CONVERT(VARCHAR,@ProductId)
WHERE IdPerson = @PersonId AND IdProduct = @ProductCatId
END
ELSE
BEGIN
INSERT INTO @SellerTable VALUES(@ProductCatId,CONVERT(VARCHAR,@ProductId),@PersonId)
END
SELECT * FROM @SellerTable
Stored Procedure
CREATE PROCEDURE InsertSeller
@PersonId INT
@ProductId INT
AS
BEGIN
DECLARE ProductCatId INT
SELECT @ProductCatId = IdProduct FROM ProductTable WHERE Id = @ProductId
IF EXISTS(SELECT Id FROM SellerTable WHERE IdPerson = @PersonId AND IdProduct = @ProductCatId)
BEGIN
UPDATE SellerTable
SET IdProductTable = IdProductTable + ',' + CONVERT(VARCHAR,@ProductId)
WHERE IdPerson = @PersonId AND IdProduct = @ProductCatId
END
ELSE
BEGIN
INSERT INTO SellerTable VALUES(@ProductCatId,CONVERT(VARCHAR,@ProductId),@PersonId)
END
END
I hope this will help you out.