CREATE TRIGGER TR_SUBECARGINSERTACT ON ACT
AFTER INSERT
	,UPDATE
AS
BEGIN
	SET NOCOUNT ON;

	DELETE
	FROM SUBECARDS
	WHERE CARDID = (
			SELECT INSERTED.ACTID
			FROM INSERTED
			)
		AND ROOT = 401

	INSERT INTO SUBECARDS (
		COMPANYID
		,ROOT
		,CARDID
		,SUBEID
		,STATUS
		,SUBEPRICE
		)
	SELECT ACT.COMPANYID
		,401
		,ACT.ACTID
		,SUBE.SUBEID
		,0
		,0
	FROM SUBE
		,ACT
	WHERE ACT.COMPANYID = (
			SELECT COMPANYID
			FROM INSERTED
			)
		AND SUBE.COMPANYID = (
			SELECT COMPANYID
			FROM INSERTED
			)
		AND ACT.ACTID = (
			SELECT INSERTED.ACTID
			FROM INSERTED
			)
END