|
i want to show data according to month like January,febuary.... i use this query Select v.varient,h.operator,Datename(month,h.dateofhit) as m_month,count(h.content_id) as No_of_hits from Tbl_hiturl h,tbl_varient v where v.content_id=h.content_id and h.state='haryana' group by v.varient,h.operator,Datename(month,h.dateofhit) it show april first that is it order by string of month howw to solve it please reply sooon Thanks in advance Regards HArdeep singh
(comments are locked)
|
|
add a ORDER BY order by datepart(month, h.dateofhit) that should put you over 1K :)
May 18 '10 at 08:15 PM
Scot Hauder
ha ha. Thanks Scot
May 19 '10 at 03:06 AM
Squirrel 1
(comments are locked)
|
|
SELECT sum(rateit) as ratecount , datename(month,commentdate) as 'MonthName' from Home_Commentdetails group by datename(month,commentdate)
(comments are locked)
|

