SET @STRINSERT=@STRIDENTITY+'INSERT INTO '+ @ARCHIVEDB +'.dbo.'+ @TableName +'('+ @ColumnList + ') SELECT * FROM (SELECT * FROM OPENQUERY'(@LinkedServerName,'SELECT '+ @ColumnList + ' FROM '+ @LIVEDB +'.dbo.'+@TableName + ' WHERE '+ @DateField + ' < CONVERT(DATETIME,'''+@ArchiveAgeDate+''',103)+ 1')'AS X'
SELECT * FROM (SELECT * FROM OPENQUERY'(@LinkedServerName,'SELECT '+ @ColumnList
SELECT * FROM (SELECT * FROM OPENQUERY(' + @LinkedServerName,'SELECT '+ @ColumnList
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)