USP_REPORT_EVENT_DAILYSCHEDULE

            create procedure dbo.USP_REPORT_EVENT_DAILYSCHEDULE
            (
                @DATE datetime = null,
                @PROGRAMID uniqueidentifier = null,
                @INCLUDEFUNDRAISINGEVENTS bit = 0
            )
            as
                set nocount on;

                if @DATE is null
                    set @DATE = getdate();

                select
                    'http://www.blackbaud.com/EVENTID?EVENTID=' + CONVERT(nvarchar(36), EVENT.ID) EVENTID,
                    PROGRAM.ID as PROGRAMID,
                    EVENT.NAME,
                    dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENT.STARTTIME) as STARTTIME,
                    dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENT.ENDTIME) as ENDTIME,
                    isnull(PROGRAM.NAME, 'Fundraising Event') as PROGRAM,
                    dbo.UFN_EVENT_GETLOCATIONNAME(EVENT.ID) as LOCATION,
                    dbo.UFN_EVENTRESOURCE_GETRESOURCESTRING(EVENT.ID) as RESOURCE,
                    dbo.UFN_EVENTSTAFFRESOURCE_GETSTAFFRESOURCESTRING(EVENT.ID) as STAFFRESOURCE
                from
                    dbo.EVENT
                    left outer join dbo.PROGRAM on PROGRAM.ID = EVENT.PROGRAMID
                where
                    STARTDATE = @DATE
                    and (
                    (PROGRAM.ISACTIVE = 1 and (@PROGRAMID is null or @PROGRAMID = PROGRAMID))
                    or (EVENT.PROGRAMID is null and EVENT.ISACTIVE = 1 and @INCLUDEFUNDRAISINGEVENTS = 1)
                    )
                order by
                    EVENT.STARTTIME,
                    LOCATION