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
/
25466
< prev
next >
Wrap
Text File
|
2010-06-15
|
1KB
|
33 lines
CREATE PROCEDURE [dbo].[ISA_spTrafficConnectionsRDL]
@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,
MaxConcurrentConnectionsPerMinute bigint
)
IF OBJECT_ID (@SummTableName, 'u') IS NOT NULL
BEGIN
DECLARE @strQuery varchar(8000)
SET @strQuery =
'SELECT
[Interval] AS Interval ,
MAX([MaxConcurrentConnectionsPerMinute]) AS MaxConcurrentConnectionsPerMinute
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