Hi ,
Check this
create trigger newcall on callbook
after insert
as
begin
declare @new int
select @new=(select max(new) from tblMRM where month=month(getdate()) and year=year(getdate()))
update tblMRM SET new=@new+1 where month=month(getdate()) and year=year(getdate());
GO
Best Regards
M.Mitwalli