How to Group by Just Date Portion Of DateTime Field

27. February 2009 AngryCoder SQL Server , TSQL Comments (0)

There are times when we need to group by the table with the date. But Datetime field also contain time part which is very deep. So, there is no way you can group by datetime field and see correct records because it will group by including the time portion of DateTime field.

So, to get rid off the time portion in group by clause here is a quick query.

        1: select  dateadd(dd,0, datediff(dd,0,dateCreated)) as Date,count(*) TotalCount  from tblRecords          2: group by dateadd(dd,0, datediff(dd,0,dateCreated))   

Maintain Scroll Position With Asp.net Validation Controls.In this post I will demonstrate you how to maintain the scroll position of asp.net validation contro...Validate username using custom validation (AJAX)In this post, I will explain you how to have an ajax call on custom validator control and check for ...Disable validation on field for specific viewConsider a case when you have single model which is bind to multiple views. For example, UserInforma