34,587
社区成员
发帖
与我相关
我的任务
分享
select convert(char(10), actdate, 111) actdate, * from YDBDLIST where sc#='B86055600' and item='1'
and substring(convert(char(10), actdate, 111),6,2) = right('00'+ltrim(str(MONTH('20080606'))), 2 )
and status<>'D1' and p_flag<>'C' order by actdate desc