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
/
25462
< prev
next >
Wrap
Text File
|
2010-06-15
|
1KB
|
47 lines
CREATE PROCEDURE [dbo].[ISA_spTrafficSummaryRDL]
@ReportType varchar(10),
@FromDate datetime,
@ToDate datetime
AS
BEGIN
DECLARE @SummTableName varchar(100)
SET @SummTableName = dbo.fnGetSummaryTableName('tblUsageSummary', @FromDate, @ToDate, @ReportType)
CREATE TABLE #Table1
(
Interval datetime,
Requests bigint,
ProcessingTime bigint,
TotalBytes bigint,
CacheHitRatio float
)
IF OBJECT_ID (@SummTableName, 'u') IS NOT NULL
BEGIN
DECLARE @strQuery varchar(8000)
SET @strQuery =
'SELECT
[Interval] AS Interval ,
SUM([Requests]) As Requests,
CASE
WHEN SUM([Requests]) = 0 THEN 0
ELSE CAST(SUM([ProcessingTime]) AS DECIMAL)/SUM([Requests])/1000
END As ProcessingTime,
SUM([TotalBytes]) AS TotalBytes,
CASE
WHEN SUM([WebRequests]) = 0 THEN 0
ELSE CAST(SUM([CacheHits]) AS decimal)/CAST(SUM([WebRequests]) AS decimal)
END As CacheHitRatio
FROM ' + @SummTableName + '
WHERE ([date] >= ' + QUOTENAME(CONVERT(varchar, @FromDate, 126),CHAR(39)) + ' AND [date] <= ' + QUOTENAME(CONVERT(varchar, @ToDate, 126),CHAR(39)) + ')
GROUP BY [Interval]
ORDER BY [Interval] ASC
'
INSERT #Table1
EXEC(@strQuery)
END
SELECT * FROM #Table1
END