quote:

---

Originally posted by icw

Hi I'm trying to crteate new trigger.
Don't tell me off for not using Raiserror - (i'm looking in ti that and trying to learn about it)

My more pressing problem here is I ge a message saying

Msg 4104, Level 16, State 1, Procedure SUMMARY_UPDATE, Line 15
The multi-part identifier "calllog.repyear" could not be bound.
Msg 4104, Level 16, State 1, Procedure SUMMARY_UPDATE, Line 15
The multi-part identifier "calllog.repmonth" could not be bound.


Here is the trigger

===================

USE [DB1]
GO
/****** Object: Trigger [dbo].[DURATION_UPDATE] Script Date: 08/04/2010 18:46:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <ICW>
-- Create date: <04/08/10>
-- Description: <Trigger to update the summary fields in calllog>
-- =============================================
create TRIGGER [dbo].[SUMMARY_UPDATE] ON [dbo].[Calllog]
FOR INSERT, UPDATE

AS

Declare @CalliD Varchar(8)
Declare @Year varchar(4)
Declare @Month varchar(9)

Select @callid=Callid FROM inserted WHERE
isnull((select top 1 calllog.repyear from calllog),'') > ''
AND
isnull((select top 1 calllog.repmonth from calllog),'') > ''

IF @Callid IS NOT NULL
Begin

Select @Year = calllog.repyear
from calllog
where callid = @callid

Select @Month = calllog.repMonth
from calllog
where callid = @callid


UPDATE CallLog
set calllog.repnumreps = t1.repsnum
from calllog,
(
select count(callid) as "repsnum" from calllog
where calllog.swerncode in (select swerncode from calllog where callid = @callid) and
Month (cast(faultstart as datetime)) = Datepart(Month,(@Month))
AND
Year(cast(faultstart as datetime)) = Datepart(Year,(@year)))
as "t1"
Where calllog.CallID = @CallID



END

---

"Select @callid=Callid FROM inserted WHERE
isnull(calllog.repyear,'') > ''
AND
isnull(calllog.repmonth,'') > ''