/****** Script for SelectTopNRows command from SSMS ******/

SELECT CONVERT(varchar(100), xfsj, 23) thedate ,sum(xfje) themoney,count(*) therenci

FROM [yifeiic].[dbo].[lssj] where xfzl=’消费’ and (xffs<>’菜单消费’ ) group by CONVERT(varchar(100), xfsj, 23) order by thedate asc

SELECT CONVERT(varchar(100), xfsj, 23) sday ,sum(xfje) zk FROM [yifeiic].[dbo].[lssj] where (xfzl=’增款’ or xfzl=’减款’)  and xffs<>’开户押金’ and xfsj between ‘2015-04-03 00:00:00′ and ‘2015-05-03 23:59:59′  group by CONVERT(varchar(100), xfsj, 23) order by sday asc