USP_DATALIST_PROPECTRESEARCHREPORTEMPLATE

                CREATE procedure dbo.USP_DATALIST_PROPECTRESEARCHREPORTEMPLATE
                (
                  @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select 
                      PROSPECTRESEARCHTEMPLATE.ID,
                      PROSPECTRESEARCHTEMPLATE.NAME,
                      PROSPECTRESEARCHTEMPLATE.DESCRIPTION,
                      PROSPECTRESEARCHTEMPLATE.ISSYSTEM,
                      case when len(APPUSER.DISPLAYNAME) = 0 then APPUSER.USERNAME else APPUSER.DISPLAYNAME end NAME,
                      case when @CURRENTAPPUSERID = PROSPECTRESEARCHTEMPLATE.OWNERID then 1 else 0 end ISMINE,
                      case when PROSPECTRESEARCHTEMPLATEDEFAULT.ID is null 
                        then 0
                        else 1 
                        end ISMYDEFAULT
                    from dbo.PROSPECTRESEARCHTEMPLATE
                    left join dbo.APPUSER
                      on PROSPECTRESEARCHTEMPLATE.OWNERID = APPUSER.ID
                    left join dbo.PROSPECTRESEARCHTEMPLATEDEFAULT
                      on PROSPECTRESEARCHTEMPLATEDEFAULT.PROSPECTRESEARCHTEMPLATEID = PROSPECTRESEARCHTEMPLATE.ID
                        and PROSPECTRESEARCHTEMPLATEDEFAULT.OWNERID = @CURRENTAPPUSERID
                    order by PROSPECTRESEARCHTEMPLATE.NAME