Comments by amit Baswa (Top 10 by date)

Hi, Above query worked for me, but need some correction in above query as follow
SELECT
SUM(Hits) AS TotalVisitor,
SUM(CASE WHEN DATEDIFF( m, VisitorDate, GETDATE() ) = 0 THEN Hits ELSE 0 END) AS VisitorThisMonth,
SUM(CASE WHEN DATEDIFF( d, VisitorDate, GETDATE() ) = 0 THEN Hits ELSE 0 END) AS VisitorToday
FROM VisitorHits

can u please give solution here.??

I am using Sql Server 2005

ok...I got your point. and I tried the following Code
function inputcall() {
return confirm("Call Client input");
}
--------------------------------
<input id="btnclick" name="btnclick" type="button" runat="server" onclick=" if (inputcall()) { __doPostBack('btnclick', ''); }" önserverclick="btnclick_ServerClick1" value="Input Button"/>



Here first I get Confirm Message, Now I was expecting that if I pressed OK then I will be postBacked and if I press Cancel then It must not call to BostBack,
But this is creating problem for me. On 'Ok' I m getting postback. But if I press Cancel then also I am getting Postback to serverSide event.
Please Suggest me.
Thanks.