and dateadd( month, -6,getdate()) > c.AllocateDate --分配半年
--and datediff(m,c.AllocateDate,getdate()) >=6
--select datediff(mm,'2009-02-17 11:25:35.700','2009-08-1 11:25:35.700')
and dateadd( month, -6,getdate()) > c.AllocateDate --分配半年
--and datediff(m,c.AllocateDate,getdate()) >=6
--select datediff(mm,'2009-02-17 11:25:35.700','2009-08-1 11:25:35.700')