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 / 25598 < prev    next >
Text File  |  2010-06-15  |  427b  |  14 lines
  1. CREATE PROCEDURE [dbo].[ISA_spUrlfTelemetryCategorizationReason]
  2.     @TruncateTable int = 1
  3. AS
  4. BEGIN
  5.     SELECT [CategorizationReason], SUM([Requests]) AS [Requests], MIN([Date]) AS [Date] 
  6.     FROM [tblUrlfTelemetryCategorizationReasonSummary_Daily]
  7.     GROUP BY [CategorizationReason]
  8.  
  9.     IF (@TruncateTable = 1)
  10.     BEGIN 
  11.         TRUNCATE TABLE [tblUrlfTelemetryCategorizationReasonSummary_Daily]
  12.     END
  13. END
  14.