Daily schedule – ‘concatenating’ multi-time periods into one block
I am working (in SQL Server 2016) on dental schedules, and by using LEAD (over PARTITION …
I can produce data of this format:
I am working (in SQL Server 2016) on dental schedules, and by using LEAD (over PARTITION …
I can produce data of this format: