Chris Loves .net | SQL Group By Date

SQL Group By Date

There are times when you want to group query results by date. Be that year month or day. The below group by clauses will achieve this for you.

Sql group by day:

GROUP BY	DATEADD(DAY,0, DATEDIFF(DAY,0, CreatedOn))

Sql group by month:

GROUP BY	DATEADD(MONTH,0, DATEDIFF(MONTH,0, CreatedOn))

Sql group by year:

GROUP BY	DATEADD(YEAR,0, DATEDIFF(YEAR,0, CreatedOn))

Use class finalizers to correctly clean up your object instances.

The Newton UX Scale, not to be confused with Newton Scale devised by Isaac Newton in 1701

Presented with the question: which is the right choice of .net technology for desktop development. I try to discern an answer.

One way to overcome a WCF Security Negotiation Exception

REST and SOAP are used when describing web services, what are the differences?