TABLE [dbo].[tdCompany](
	[CompanyNo] [int] IDENTITY(1,1) NOT NULL,
	[CompanyName] [varchar](20) NULL,
	[AXDataArea] [varchar](3) NULL
) ON [PRIMARY]

TABLE [dbo].[tdCompany_Modife](
	[CompanyName] [varchar](20) NOT NULL,
	[CountRows] [int] NOT NULL,
	[TypeTransaction] [varchar](20) NOT NULL,
	[ModifeDate] [datetime] NOT NULL
) ON [PRIMARY]

ALTER TRIGGER [dbo].[Ins_tdCompany]
ON [dbo].[tdCompany] AFTER INSERT
AS
BeGIN
SET NOCOUNT ON;
update tdCompany_Modife 
set CompanyName =  ii.CompanyName
, CountRows=ii.countrows
, TypeTransaction='UPDATE'
, ModifeDate=getdate()
from 
(select com.CompanyName,count(i.CompanyNo) as CountRows from tdCompany com  inner join  inserted i on i.CompanyNo=com.CompanyNo group by com.CompanyName)  ii

END