CREATE TRIGGER [dbo].[InsertDatFXActualStaging]
ON [dbo].[DatFXActualStaging]--change this table to DatFXActualStaging
for INSERT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @Fiscper INT


select @Fiscper=CONVERT(int,
substring(convert(varchar,MAX(effectivedate),105),7,4) 
+
case 
when substring(convert(varchar,MAX(effectivedate),105),4,2)='10' then '001'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='11' then '002'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='12' then '003'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='01' then '004'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='02' then '005'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='03' then '006'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='04' then '007'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='05' then '008'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='06' then '009'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='07' then '010'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='08' then '011'
when substring(convert(varchar,MAX(effectivedate),105),4,2)='09' then '012'
end)
from dbo.DatFXActualStaging 
where effectivedate=(select MAX(effectivedate) from inserted);

exec [usp_fagflexb_territory_currency] @Fiscper,1,1
exec [usp_fagflexb_overhead_territory_currency] @Fiscper,1,1
SET NOCOUNT OFF;

END