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
/
25534
< prev
next >
Wrap
Text File
|
2010-06-15
|
1KB
|
50 lines
CREATE PROCEDURE [dbo].[ISA_spGetCounter]
@tblBaseName varchar(50),
@CounterColumn varchar(50),
@Condition varchar(200),
@FromDate datetime,
@ToDate datetime,
@ReportType varchar(10),
@Counter bigint OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @SummTableName varchar(100)
SET @SummTableName = dbo.fnGetSummaryTableName(@tblBaseName, @FromDate, @ToDate, @ReportType)
CREATE TABLE #Table1
(
Counter bigint
)
IF OBJECT_ID (@SummTableName, 'u') IS NOT NULL
BEGIN
DECLARE @strQuery varchar(8000)
SET @strQuery =
'SELECT
SUM([' + @CounterColumn + ']) AS [Counter]
FROM ' + @SummTableName +
' WHERE ([date] >= ' + QUOTENAME(CONVERT(varchar, @FromDate, 126),CHAR(39)) + ' AND [date] <= ' + QUOTENAME(CONVERT(varchar, @ToDate, 126),CHAR(39)) + ')'
if @Condition is NOT NULL
SET @strQuery = @strQuery + ' AND
(' + @Condition + ')'
INSERT #Table1
EXEC(@strQuery)
SET @Counter = (SELECT SUM(Counter) FROM #Table1)
IF @Counter IS NULL
BEGIN
SET @Counter = 0
END
END
ELSE
BEGIN
SET @Counter = 0
END
END