USP_DATALIST_TRACKITEM

                CREATE procedure dbo.USP_DATALIST_TRACKITEM
                (
                    @TRACKID uniqueidentifier
                )
                as
                    set nocount on;

                    -- Hack for making the calendar appear as if it doesn't have specific dates

                    declare @STARTDATE datetime;
                    set @STARTDATE = '2001-1-1';

                    select
                        ID,
                        NAME,
                        case
                            when EVENTLOCATIONID is not null then
                                dbo.UFN_EVENTLOCATION_GETNAME(EVENTLOCATIONID)
                            else
                                dbo.UFN_PROGRAM_GETLOCATIONNAME(PROGRAMID)
                        end [LOCATION],
                        dbo.UFN_TRACKITEMRESOURCE_GETRESOURCESTRING(TRACKITEM.ID) as RESOURCES,
                        dbo.UFN_TRACKITEMSTAFFRESOURCE_GETSTAFFRESOURCESTRING(TRACKITEM.ID) as STAFFRESOURCES,
                        STARTDAY,
                        STARTTIME,
                        ENDDAY,
                        ENDTIME,
                        BLOCKEVENT,
                        NOTES,
                        dateadd(day, STARTDAY, @STARTDATE) [STARTDATE],
                        dateadd(day, ENDDAY, @STARTDATE) [ENDDATE],
                        TYPECODE,
                        case TYPECODE
                            when 0 then
                                'DarkSeaGreen'
                            when 1 then
                                'CornflowerBlue'
                            else
                                'PaleVioletRed'
                        end [BACKCOLOR]
                    from
                        dbo.TRACKITEM
                    where
                        TRACKID = @TRACKID
                    order by
                        STARTDAY,
                        STARTTIME;

                    return 0;