UFN_TRANSLATIONFUNCTION_PROGRAMEVENTFORRESCHEDULE

create function dbo.UFN_TRANSLATIONFUNCTION_PROGRAMEVENTFORRESCHEDULE(@ID uniqueidentifier) 
returns nvarchar(50)
as begin
    return (
        -- We're not using the convert function for the date because we need to minimize space usage.

        -- As of 2/4/2014, the generated string should look like "9/20, Fri, 5:00 PM-7:00 PM, 22 Avail"


        select cast(datepart(month, STARTDATE) as nvarchar(2)) + '/' + cast(datepart(day, STARTDATE) as nvarchar(2)) + ', '
            + left(datename(weekday, STARTDATE), 3) + ', '
            + dbo.UFN_HOURMINUTE_DISPLAYTIME(STARTTIME) + '-' + dbo.UFN_HOURMINUTE_DISPLAYTIME(ENDTIME) + ', '
            + cast(cast(TICKETCOUNTS.[AVAILABILITY] as int) as nvarchar(10)) + ' Avail'
        from dbo.[EVENT]
        inner join dbo.V_PROGRAMEVENT_TICKETCOUNTS TICKETCOUNTS on TICKETCOUNTS.ID = [EVENT].ID
        where [EVENT].ID = @ID

    );
end