select top 31 sum(V_View),sum(V_IP),cast(year(V_DTime) as varchar(4)) + '-' + cast(month(V_DTime) as varchar(2)) + '-' cast(day(V_DTime) as varchar(2)) from User_View
where Site_ID=1 and V_DTime<= '2005-9-13'
group by V_DTime order by V_DTime
where Site_ID=1 and V_DTime<= '2005-9-13'
group by V_DTime order by V_DTime
where Site_ID=1 and V_DTime<= '2005-9-13'
group by V_DTime order by V_DTime
top 31 sum(V_View),sum(V_IP),convert(char(10),V_DTime,120)
from
User_View
where
Site_ID=1 and V_DTime<= '2005-9-13'
group by
convert(char(10),V_DTime,120)
order by
convert(char(10),V_DTime,120)