home *** CD-ROM | disk | FTP | other *** search
/ moodle.waes.ac.uk / moodle.waes.ac.uk.zip / moodle.waes.ac.uk / TMG / SP1-TMG-KB981324-AMD64-ENU.msp / PCW_CAB_SHFx2 / F2143_msfpcui.dll / BINARY / 25143 < prev    next >
Text File  |  2010-06-15  |  1KB  |  41 lines
  1. CREATE PROCEDURE [dbo].[ISA_spUrlfSummaryMonthly] 
  2.     @CurrentMonthFirstDay datetime,
  3.     @CurrentMonthLastDay datetime,
  4.     @LastDailyToKeep datetime,
  5.     @LastMonthlyToKeep datetime
  6. AS
  7. BEGIN
  8.     SET NOCOUNT ON;
  9.  
  10. -- move dailies to monthlies
  11.     INSERT INTO dbo.tblUrlfSummary_Monthly
  12.     SELECT 
  13.             [UrlCategoryId] AS [UrlCategoryId],
  14.             [CategorizationReason] AS [CategorizationReason],
  15.             [Action] AS Action,
  16.             [UrlfMatched] AS UrlfMatched,
  17.             SUM(Requests),
  18.             SUM([BytesIn]),
  19.             SUM([BytesOut]),
  20.             SUM([TotalBytes]),
  21.             @CurrentMonthFirstDay AS Date,
  22.             '-' As [ServerName]
  23.     FROM dbo.tblUrlfSummary_Daily
  24.     WHERE (Date >= @CurrentMonthFirstDay) AND
  25.           (Date <= @CurrentMonthLastDay)
  26.     GROUP BY
  27.             [UrlCategoryId],
  28.             [CategorizationReason],
  29.             [Action],
  30.             [UrlfMatched]
  31.  
  32. -- cleanup dailies
  33.     DELETE FROM [ISA_RS_Db].[dbo].[tblUrlfSummary_Daily]
  34.     WHERE (Date < @LastDailyToKeep)
  35.  
  36. -- cleanup monthlies
  37.     DELETE FROM [ISA_RS_Db].[dbo].[tblUrlfSummary_Monthly]
  38.     WHERE (Date < @LastMonthlyToKeep)
  39.  
  40. END
  41.