like 里面的值是变化的要怎么写？
select b.empno,b.buildid
from
(select *
from openquery (TEST, 'select /*+ RULE */ * from db1.ta_show
where compcd=''11'' and corpcd=''C11'' and workdt like ''201301%''
') ) a,(select *
from openquery (TEST, 'select /*+ RULE */ * from db1.tb_show
where compcd=''11'' and corpcd=''C11'' and statuscd=''D''
')) b
where a.id=b.id
这样写可以查出数据，，，如果 workdt like ''201301%''
不要写死的，要是当月，
left(CONVERT(varchar(100), GETDATE(), 112),6) 能得到201301
但如果把这放进去
select b.empno,b.buildid
from
(select *
from openquery (TEST, 'select /*+ RULE */ * from db1.ta_show
where compcd=''11'' and corpcd=''C11'' and workdt like ''left(CONVERT(varchar(100), GETDATE(), 112),6)%''
') ) a,(select *
from openquery (TEST, 'select /*+ RULE */ * from db1.tb_show
where compcd=''11'' and corpcd=''C11'' and statuscd=''D''
')) b
where a.id=b.id
又不对，得怎么写好呢?
[解决办法]
当月的话，lz是否可以用
datediff(yy,col,getdate()) =0 and datediff(mm,col,getdate())=0
来处理？
参考
DECLARE @i DATETIME
SET @i = '2013-01-01'
SELECT CASE WHEN datediff(yy,@i,getdate()) =0 and datediff(mm,@i,getdate())=0 THEN '同月' ELSE '不同月' END
--同月
