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
/
25606
< prev
next >
Wrap
Text File
|
2010-06-15
|
457b
|
16 lines
CREATE PROCEDURE [dbo].[ISA_spUrlfTelemetrySiteSummary]
@TruncateTable int = 1
AS
BEGIN
DECLARE @NthUrl int = (SELECT [NthUrl] FROM [tblUrlfTelemtryConfig])
SELECT [Site] , SUM([Requests]) AS [Requests], MIN([Date]) AS [Date] , @NthUrl AS [NthUrl]
FROM [tblUrlfTelemetrySiteSummary_Daily]
GROUP BY [Site]
IF (@TruncateTable = 1)
BEGIN
TRUNCATE TABLE [tblUrlfTelemetrySiteSummary_Daily]
END
END