Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Powershell: ReportingServicesTools. Download all RDL files from a SSRS folder. May 9, 2023
  • SSIS error: 0xC0048021SSIS April 4, 2023
  • Easy way using SSIS to copy files to S3 storage. March 7, 2023
  • SSIS Hresult: 0x80004005 Consider using the WITH RESULT SETS clause to explicitly describe the result set.SSIS Hresult: 0x80004005 February 8, 2023
  • How to install SQL Server Reporting Services (SSRS) 2022 January 4, 2023
June 2023
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« May    

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