I need to make this into a SQL Server 2000 trigger....

SELECT pk_appid ;
FROM Monitoring ;
WHERE Monitoring.pk_appid = resources.pk_resource ;
INTO CURSOR (curMonitoring)

SELECT Monitoring
IF RECCOUNT('curMonitoring') = 0
APPEND BLANK
ENDIF

Replace Monitoring.pk_appid WITH resources.pk_resource ,;
Monitoring.ApplicationName WITH resources.resdesc


....the trigger obviously would to in the 'resources' table...anyone know what the trigger syntax should be?

Thanks!