知足而常乐

摘要： select count(v.ID) as TodayCount,c.Name,c.VoteCount,c.trabeType,c.Number from vote v,CMS_U_Vote c where v.ID=c.ID and (Select CONVERT(varchar(100),v.VoteTime, 23)) =(Select CONVERT(varchar(100), getdate(), 23)) group by v.ID,c.NAME,c.VoteCount,c.trabeType,c.Number 阅读全文