Fill in missing dates for a vacation schedule Have an issue that has been driving me nuts for the past week and can't seem to get my head around it.

I have a stored procedure that grabs a bunch of vacation requests from our scheduling system. I need to now get each day that the individual has requested into a single row to pivot and plot in excel at the request of the user.



This is the end result I am looking for in a SQL Table



Any help is appreciated, already have a datedimension table created, tried using CTE and another attempt using outer apply but at this point I am spinning my wheels.  

UPDATE:  Calendar Table  

This is the table (Calendar Table) I am using - Populated with 30 years of dates  

CREATE TABLE [dbo].[DateDimension](
    [Date] [date] NOT NULL,
    [Day] [tinyint] NOT NULL,
    [DaySuffix] [char](2) NOT NULL,
    [Weekday] [tinyint] NOT NULL,
    [WeekDayName] [varchar](10) NOT NULL,
    [IsWeekend] [bit] NOT NULL,
    [IsHoliday] [bit] NOT NULL,
    [HolidayText] [varchar](64) SPARSE  NULL,
    [DOWInMonth] [tinyint] NOT NULL,
    [DayOfYear] [smallint] NOT NULL,
    [WeekOfMonth] [tinyint] NOT NULL,
    [WeekOfYear] [tinyint] NOT NULL,
    [ISOWeekOfYear] [tinyint] NOT NULL,
    [Month] [tinyint] NOT NULL,
    [MonthName] [varchar](10) NOT NULL,
    [Quarter] [tinyint] NOT NULL,
    [QuarterName] [varchar](6) NOT NULL,
    [Year] [int] NOT NULL,
    [MMYYYY] [char](6) NOT NULL,
    [MonthYear] [char](7) NOT NULL,
    [FirstDayOfMonth] [date] NOT NULL,
    [LastDayOfMonth] [date] NOT NULL,
    [FirstDayOfQuarter] [date] NOT NULL,
    [LastDayOfQuarter] [date] NOT NULL,
    [FirstDayOfYear] [date] NOT NULL,
    [LastDayOfYear] [date] NOT NULL,
    [FirstDayOfNextMonth] [date] NOT NULL,
    [FirstDayOfNextYear] [date] NOT NULL
) ON [PRIMARY]
GO
You can do this with a CROSS APPLY that will generate the dates.

SELECT m.requestor, m.schedcode, o.Date FROM mockup m
CROSS APPLY (
    SELECT  TOP (DATEDIFF(DAY, m.fromdate, m.enddate) + 1)
        Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, m.fromdate)
        FROM    sys.all_objects a
        CROSS JOIN sys.all_objects b
) AS o


Props to GarethD's answer at Get all dates between two dates in SQL Server for the date generating code.