DECLARE @Sql VARCHAR(1000)
DECLARE @TaskMonth VARCHAR(1000)
set @TaskMonth ='201602'
SET @Sql = 'select AREANO,STATIONNO,CHANNELNO,MEDIATYPE '
SET @Sql = @Sql+' FROM OPENQUERY(TEST, ''SELECT AREANO,STATIONNO,CHANNELNO,MEDIATYPE '
SET @Sql = @Sql+' FROM T_RECORDERPLAN where TASKMONTH = '''''+@TaskMonth+''''' '')'
print(@Sql)
EXEC(@Sql)
DECLARE @TaskMonth VARCHAR(1000)
set @TaskMonth ='201602'
SET @Sql = 'select AREANO,STATIONNO,CHANNELNO,MEDIATYPE '
SET @Sql = @Sql+' FROM OPENQUERY(TEST, ''SELECT AREANO,STATIONNO,CHANNELNO,MEDIATYPE '
SET @Sql = @Sql+' FROM T_RECORDERPLAN where TASKMONTH = '''''+@TaskMonth+''''' '')'
print(@Sql)
EXEC(@Sql)