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 / 25218 < prev    next >
Text File  |  2010-06-15  |  977b  |  29 lines
  1. CREATE PROCEDURE [dbo].[ISA_spBranchCacheSummaryMonthly] 
  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.tblBranchCacheSummary_Monthly
  12.     SELECT 
  13.         @CurrentMonthFirstDay AS [Date],
  14.         SUM([TMGCacheOutKB]) AS [TMGCacheOutKB],
  15.         SUM([TMGCacheInKB]) AS [TMGCacheInKB],
  16.         SUM([HostedCacheOutKB]) AS [HostedCacheOutKB],
  17.         SUM([HostedCacheInKB]) AS [HostedCacheInKB]
  18.     FROM dbo.tblBranchCacheSummary_Daily
  19.     WHERE (Date >= @CurrentMonthFirstDay) AND (Date <= @CurrentMonthLastDay)
  20.             
  21.     -- cleanup dailies
  22.     DELETE FROM [ISA_RS_Db].[dbo].[tblBranchCacheSummary_Daily]
  23.     WHERE (Date < @LastDailyToKeep)
  24.  
  25.     -- cleanup monthlies
  26.     DELETE FROM [ISA_RS_Db].[dbo].[tblBranchCacheSummary_Monthly]
  27.     WHERE (Date < @LastMonthlyToKeep)
  28. END
  29.