USP_TIXEVENT_GETINFOFORCOPY

            create procedure dbo.USP_TIXEVENT_GETINFOFORCOPY
            (
                @ID uniqueidentifier
            )
            as

            select
                NAME,
                PROGRAMID,
                DESCRIPTION,
                CAPACITY,
                dbo.UFN_HOURMINUTE_GETFROMDATE(STARTTIME) as STARTTIMEHM,
                dbo.UFN_HOURMINUTE_GETFROMDATE(ENDTIME) as ENDTIMEHM,
                EVENTLOCATIONID
            from dbo.TIXEVENT
            where @ID = ID