Calendar Table

SQLServerCentral Article

4.9 (10)

2022-07-13

8,781 reads

External Article

Time Slots - An Essential Extension to Calendar Tables

  • Article

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.

2015-05-05

7,291 reads

Blogs

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Managed Instance Link and SQL Server 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Managed Instance Link and SQL...

Passing parameters to query without TVFs

By seanachim@hotmail.com

Comments posted to this topic are about the item Passing parameters to query without...

Capturing Data Changes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Capturing Data Changes

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers