Hi ,

CREATE TABLE #prod(Product_Code varchar(10),Product_Name varchar(100))

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('123','Product_1')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('234','Product_2')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('345','Product_3')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('345','Product_3')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES ('456','Product_4')

INSERT INTO #prod(Product_Code, Product_Name)

VALUES...