USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERAVAILABILITY

                    CREATE procedure dbo.USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERAVAILABILITY
                    (
                        @CONSTITUENTID uniqueidentifier,
                        @ISVISIBLE bit = 1
                    )
                    as
                        set nocount on;

                        if @ISVISIBLE = 1
                        begin
                            select
                                    STARTDATE,
                                    ENDDATE,
                                    DAYOFWEEK,
                                    dbo.UFN_HOURMINUTE_DISPLAYTIME(STARTTIME) as STARTTIME,
                                    dbo.UFN_HOURMINUTE_DISPLAYTIME(ENDTIME) as ENDTIME,
                                    FULLSTARTDATE,
                                    FULLENDDATE
                            from dbo.VOLUNTEERAVAILABILITY
                            where VOLUNTEERID = @CONSTITUENTID
                            order by STARTDATE, ENDDATE;
                        end