Trigger

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER trigger [tgcom] ON [dbo].[tblTabInfo] after insert
as
declare @foid as varchar(50)
declare @com as decimal(20,2)
declare @qu varchar(10)
select @com=(select focash from tblTableInfo where tableID =(select distinct(tableID) from tblTabInfo where fo_id='0353F1'))
select @qu=(select q_no from tblquarter where getdate() between start_date and end_date )
select @foid= fo_id from inserted
insert into tblcommision_details values (@foid,getdate(),@com,@qu)
update tblcommision set amount=convert(decimal(20,2),amount)+ @com where emp_code=@foid and q_id=@qu
begin
exec focommison @foid, @com
end