DECLARE @logid INT IF EXISTS(SELECT logID FROM logWatcherLogs WHERE logName = ) BEGIN UPDATE logWatcherLogs SET HitCount = hitCount + 1 WHERE logName = SELECT @logid = logID FROM logWatcherLogs WHERE logName = END ELSE BEGIN INSERT INTO logWatcherLogs(logName,hitCount) VALUES(,1) SET @logID = SCOPE_IDENTITY() END IF EXISTS (SELECT severityID FROM logWatcherSeverity WHERE severity = AND logID = @logid) BEGIN UPDATE logWatcherSeverity SET hitCount = hitCount + 1 WHERE severity = AND logID = @logid END ELSE BEGIN INSERT INTO logWatcherSeverity(logID,severity,hitCount) VALUES(@logID,,1) END IF EXISTS (SELECT applicationID FROM logWatcherApplication WHERE application = AND logID = @logid) BEGIN UPDATE logWatcherApplication SET hitCount = hitCount + 1 WHERE application = AND logID = @logid END ELSE BEGIN INSERT INTO logWatcherApplication(logID,application,hitCount) VALUES(@logID,,1) END IF EXISTS (SELECT pageID FROM logWatcherpage WHERE page = AND logID = @logid) BEGIN UPDATE logWatcherpage SET hitCount = hitCount + 1 WHERE page = AND logID = @logid END ELSE BEGIN INSERT INTO logWatcherpage(logID,page,hitCount) VALUES(@logID,,1) END IF EXISTS (SELECT threadID FROM logWatcherthread WHERE thread = AND logID = @logid) BEGIN UPDATE logWatcherthread SET hitCount = hitCount + 1 WHERE thread = AND logID = @logid END ELSE BEGIN INSERT INTO logWatcherthread(logID,thread,hitCount) VALUES(@logID,,1) END IF EXISTS (SELECT dateID FROM logWatcherDate WHERE date = AND logID = @logid) BEGIN UPDATE logWatcherDate SET hitCount = hitCount + 1 WHERE date = AND logID = @logid END ELSE BEGIN INSERT INTO logWatcherdate(logID,date,hitCount) VALUES(@logID,,1) END UPDATE logWatcherLastRun SET lastRun = SELECT lastRun FROM logWatcherLastRun