34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @month NVARCHAR(100),@sql NVARCHAR(100)
SET @month='1409,1410,1411'
SET @sql='SELECT * FROM [CRMReporting].[dbo].[SplitToTable]('''+@month+''','','')'
SET @SQL=REPLACE(@SQL,'''','''''')
SET @sql='SELECT MAX(CAST(value AS INT)) FROM OPENQUERY([10.237.70.214],'''+@sql+''')'
EXEC(@sql)
应该是这样子