Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Add Parameter to SSRS Report April 10, 2018
  • Create SSRS report with a query March 21, 2018
  • Speed up Linked Server Connection To Oracle using OPENQUERY February 27, 2018
  • SQL Saturday #708 Cleveland 2018 February 11, 2018
  • Linked Server that connects to Oracle January 17, 2018
April 2018
M T W T F S S
« Mar    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Tag: datapart

Count Rows per Hour

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.

Continue reading Count Rows per Hour

Posted on April 4, 2017March 12, 2017Categories Hints and TipsTags datapart, rows per hourLeave a comment on Count Rows per Hour
Create a website or blog at WordPress.com