USP_DATALIST_CONSTITUENTPROFILEDASHBOARDVOLUNTEERTIMESHEET

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

                    if @ISVISIBLE = 1
                    begin
                        select
                            JOB.NAME as [JOBNAME],
                            JOBOCCURRENCE.DESCRIPTION as [JOBOCCURRENCE],
                            TIMESHEET.HOURSWORKED,
                            TIMESHEET.STARTDATE,
                            TIMESHEET.ENDDATE
                        from dbo.TIMESHEET
                        inner join dbo.JOBOCCURRENCE on JOBOCCURRENCE.ID = TIMESHEET.JOBOCCURRENCEID
                        inner join dbo.JOB on JOB.ID = JOBOCCURRENCE.JOBID
                        where TIMESHEET.VOLUNTEERID = @CONSTITUENTID
                        order by STARTDATE desc, JOBNAME, JOBOCCURRENCE, HOURSWORKED;
                    end