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
/
25026
< prev
next >
Wrap
Text File
|
2010-06-15
|
2KB
|
41 lines
CREATE PROCEDURE [dbo].[ISA_spCommitSingleSummary]
@tblName varchar(100),
@RemoteTblName varchar(300),
@RemoteRegistryTblName varchar(300)
AS
BEGIN
SET NOCOUNT ON;
IF OBJECT_ID (@tblName, 'u') IS NOT NULL
BEGIN
PRINT 'Table ' + @tblName + ' found. Committing summary'
DECLARE @tblExists int
-- create empty table on remote
DECLARE @strPushSQLStatement varchar(500)
DECLARE @strSQL varchar(500)
SET @strSQL = 'RS_SRV.ISA_RS_Db.dbo.ISA_spDuplicateEmptyTable ' + QUOTENAME(@tblName, char(39)) + ', ' + QUOTENAME(@RemoteTblName, char(39)) + ', 1'
--PRINT 'Executing: ' + @strSQL
EXECUTE (@strSQL)
-- move the data from local tbl to remote tbl
SET @strPushSQLStatement =
'INSERT INTO RS_SRV.[ISA_RS_Db].[dbo].' + @RemoteTblName + ' SELECT * FROM ' + @tblName
--PRINT 'Executing: ' + @strPushSQLStatement
EXECUTE (@strPushSQLStatement)
-- register the remote tbl for flushing
SET @strPushSQLStatement =
'INSERT INTO RS_SRV.[ISA_RS_Db].[dbo].' + @RemoteRegistryTblName + ' ([TempTableName], [TableName])
VALUES (' + QUOTENAME(@RemoteTblName, char(39)) + ', ' + QUOTENAME(@tblName, char(39)) + ')'
--PRINT 'Executing: ' + @strPushSQLStatement
EXECUTE (@strPushSQLStatement)
END
ELSE
BEGIN
PRINT 'Table ' + @tblName + ' not found. Nothing to commit'
END
END