INSERT INTO LINKSET_DAILY_HIGH 
SELECT 
	Linkset_Name, Start_Date_Time, Start_Date_Time, Hour_Of_Day,
	Sequence_In_Hour, Link_Count, Trans_ISUP_Oct, Trans_SCCP_Oct,
	Trans_Other_Oct, Recv_ISUP_Oct, Recv_SCCP_Oct, Recv_Other_Oct,
	Total_Bandwidth, High_PCT_Occupancy
FROM inserted 

UPDATE l
SET start_date_time = i.start_date_time,
hour_of_day = i.hour_of_day,
sequence_in_hour = i.sequence_in_hour,
link_count = i.link_count,
trans_isup_oct = i.trans_isup_oct,
trans_sccp_oct = i.trans_sccp_oct,
trans_other_oct = i.trans_other_oct,
recv_isup_oct = i.recv_isup_oct,
recv_sccp_oct = i.recv_sccp_oct,
recv_other_oct = i.recv_other_oct,
total_bandwidth = i.total_bandwidth,
high_pct_occupancy = i.high_pct_occupancy
FROM LINKSET_DAILY_HIGH l
INNER JOIN inserted i
ON 
	l.PKColumnGoesHere = i.linkset_name AND 
	l.start_date_text = i.start_date_time AND
	l.high_pct_occupancy < i.high_pct_occupancy

quote:

---

Originally posted by Rliss

Thank You Tara, that worked perfectly. I've been spoiled in Oracle where I didn't have to reference the trigger tables by 'select where exists' or 'inner join'. By force, I am learning quickly. Thanks again, you're the best...

RLiss

---

CREATE TRIGGER updEmployeeData 
ON employeeData 
FOR update AS
/*Check whether columns 2, 3 or 4 has been updated. 
If any or all of columns 2, 3 or 4 have been changed, 
create an audit record. The bitmask is: 
power(2,(2-1))+power(2,(3-1))+power(2,(4-1)) = 14. 
To check if all columns 2, 3, and 4 are updated, 
use = 14 in place of >0 (below).*/

   IF (COLUMNS_UPDATED() & 14) > 0
/*Use IF (COLUMNS_UPDATED() & 14) = 14 
to see if all of columns 2, 3, and 4 are updated.*/
      BEGIN
-- Audit OLD record.
      INSERT INTO auditEmployeeData
         (audit_log_type,
         audit_emp_id,
         audit_emp_bankAccountNumber,
         audit_emp_salary,
         audit_emp_SSN)
         SELECT 'OLD', 
            del.emp_id,
            del.emp_bankAccountNumber,
            del.emp_salary,
            del.emp_SSN
         FROM deleted del

-- Audit NEW record.
      INSERT INTO auditEmployeeData
         (audit_log_type,
         audit_emp_id,
         audit_emp_bankAccountNumber,
         audit_emp_salary,
         audit_emp_SSN)
         SELECT 'NEW',
            ins.emp_id,
            ins.emp_bankAccountNumber,
            ins.emp_salary,
            ins.emp_SSN
         FROM inserted ins
   END
GO