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 / 25203 < prev    next >
Text File  |  2010-06-15  |  591b  |  18 lines
  1. CREATE PROCEDURE [dbo].[ISA_spTrimArrayUrlfSummary]
  2.     @FromDate datetime,
  3.     @ToDate   datetime
  4. AS
  5. BEGIN
  6.     SET NOCOUNT ON;
  7.     IF OBJECT_ID ('tblUrlfTelemetrySiteSummary_Daily', 'u') IS NOT NULL
  8.     BEGIN
  9.         DELETE FROM [tblUrlfTelemetrySiteSummary_Daily]
  10.         WHERE ([Date] >= @FromDate) AND ([Date] < @ToDate)
  11.     END
  12.     IF OBJECT_ID ('tblUrlfTelemetryCategorizationReasonSummary_Daily', 'u') IS NOT NULL
  13.     BEGIN
  14.         DELETE FROM [tblUrlfTelemetryCategorizationReasonSummary_Daily]
  15.         WHERE ([Date] >= @FromDate) AND ([Date] < @ToDate)
  16.     END
  17. END
  18.