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
/
25526
< prev
next >
Wrap
Text File
|
2010-06-15
|
1KB
|
33 lines
CREATE PROCEDURE [dbo].[ISA_spFlushSingleServerSummary]
@TempTblName varchar(300),
@TblName varchar(300)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @PermanentTblName varchar(300)
SET @PermanentTblName = dbo.fnGetSummaryTableName(@TblName, GETDATE(), GETDATE() , 'Daily')
IF OBJECT_ID (@TempTblName, 'u') IS NOT NULL
BEGIN
PRINT 'Table ' + @TempTblName + ' found. Committing summary'
DECLARE @strPushSQLStatement varchar(500)
EXECUTE ISA_RS_Db.dbo.ISA_spDuplicateEmptyTable @TempTblName, @PermanentTblName, 0
SET @strPushSQLStatement =
'INSERT INTO [ISA_RS_Db].[dbo].' + @PermanentTblName + ' SELECT * FROM ' + @TempTblName
PRINT 'Executing: ' + @strPushSQLStatement
EXECUTE (@strPushSQLStatement)
SET @strPushSQLStatement = 'DROP TABLE ' + @TempTblName
PRINT 'Executing: ' + @strPushSQLStatement
EXECUTE (@strPushSQLStatement)
END
ELSE
BEGIN
PRINT 'Table ' + @TempTblName + ' not found. Nothing to commit'
END
END