Would this work?

Creates schedules and shifts tables.

USE [CCAP]

GO

/****** Object: Table [dbo].[Schedules] Script Date: 5/7/2019 1:18:38 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [#Schedules](

[ScheduleName] [varchar](30) NULL,

[ScheduleBeginDay] [varchar](10) NULL,

[ShiftName] [varchar](30) NULL,

[ScheduleStart] [datetime]...

Jonathan AC Roberts, I popped your code into my editor and ran it.

Ran without modification. Kudos to you for doing that without being able to test.

It almost worked perfectly in...

• This reply was modified 5 years, 6 months ago by  Darrell Woodard.
• This reply was modified 5 years, 6 months ago by  Darrell Woodard.

You are correct that the distinct is not needed.

The USE CCAP was in there twice because i was testing code in SSMS and needed it in the second spot while...

the first issue I see with the code above from Jonathan AC Roberts is that the schedule times would only show if day 1 has a person scheduled.

Solved: based on the following suggestion from another programmer: Instead of a single date, @startDate, load all dates into a dates table, then left join from those dates to the...

SSCoach, sorry about that. I was fiddling with the code and forgot to change it back.

from @startDate

left outer join Schedules day1

should be

from  Schedules day1