Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • SSMS: Saving changes is not permitted error June 7, 2022
  • SQL Server: TableSample clause May 4, 2022
  • T-SQL: Create a running total April 6, 2022
  • Sql Server: Find the location your backups are going to. March 3, 2022
  • Oracle: Database will not startup due to invalid parameter February 8, 2022
July 2022
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Jun    

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
  • Follow Following
    • Jim Salasek's SQL Server Blog
    • Join 27 other followers
    • Already have a WordPress.com account? Log in now.
    • Jim Salasek's SQL Server Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar