Here is a useful technique to know. We have a delivery service and we want to know what hour of the day is most popular for completed deliveries. Using the DATEPART function, this can be easily calculated.
Here is a useful technique to know. We have a delivery service and we want to know what hour of the day is most popular for completed deliveries. Using the DATEPART function, this can be easily calculated.
Jim Salasek's SQL Server Blog 