Query help sql date range between grouping 7am to 7am

[pturmel]

At some point you are going to be asked to collect and summarize by rotating shifts with arbitrary rotation patterns. It can get complicated. The following generic solution may help you create the correct joins against your production records:

Script for periodically changing shift time

Hi Berkay, I like to solve this kind of problem with a smart database, like PostgreSQL, where I can define a pattern and repeat it with table generating functions. I tweaked one of my implementations to serve as an example: create table shift_schedules (shift_id serial, shift_name varchar(255), refdate date, repeat int, tzname varchar(255), primary key (shift_id)); insert into shift_schedules (shift_name, refdate, repeat, tzname) values ('Berkay Cinar 3wk', '2021-07-26', 21, 'America/Ne…

You'll have to tweak it for use with SQL Server.