Tables (3,4,5)

INSERT INTO Products_type2
(productid_app, productname, package, effective_date)
VALUES(?, ?, ?,

?)

productid_app
productname
package
effective_date

1
2
3
4

EXEC
Destination..usp_Update_Products_type2
@productid_app = ?,
@productname = ?,
@package = ?,
@effective_date = ?

productid_app
productname
package
effective_date

1
2
3
4

UPDATE Products_type2
SET discontinued = 1
WHERE productid_app = ?

INSERT INTO Products_type3
(productid_app, productname, package, effective_date)
VALUES(?, ?, ?, ?)

productid_app
productname
package
effective_date

1
2
3
4

EXEC
Destination..usp_Update_Products_type3
@productid_app = ?,
@productname = ?,
@package = ?,
@effective_date = ?

productid_app
productname
package
effective_date

1
2
3
4

UPDATE Products_type3
SET discontinued = 1