UFN_TRANSLATIONFUNCTION_RESCHEDULETICKETSAVAILABLEEVENT

create function dbo.UFN_TRANSLATIONFUNCTION_RESCHEDULETICKETSAVAILABLEEVENT(@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 "Wed, 9/20/2013-10:00AM, 1 Avail"


        select left(datename(weekday, STARTDATE), 3)
            + ', ' + cast(datepart(month, STARTDATE) as nvarchar(2)) + '/' + cast(datepart(day, STARTDATE) as nvarchar(2)) + '/' + cast(datepart(year, STARTDATE) as nvarchar(4))
            + ' - ' + dbo.UFN_HOURMINUTE_DISPLAYTIME(STARTTIME)
            + ', ' + 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