i create trigger to get some values and wann to insert it into table when i open thers is empty columns in table any help please??
ALTER trigger [dbo].[rptFees] on [dbo].[Sessions_]After insert
as Begin Declare @mcid int Declare @prc float set @prc=(select [perce] from [dbo].[MCpercentage] where [MCID]=@mcid) Declare @Totalapp float Declare @TotalMC float set @TotalMC=(select [TotalFees] from[dbo].[Sessions_] where MCID=@mcid) set @Totalapp=@TotalMC-(@TotalMC*(@prc/100)) Declare @TotalOfMC float set @TotalOfMC=@TotalMC-@Totalapp insert into [dbo].mcFees values (@TotalOfMC,@Totalapp,@prc,@mcid)
End