USP_SIMPLEDATALIST_SITESFORUSERMOBILE

CREATE procedure dbo.USP_SIMPLEDATALIST_SITESFORUSERMOBILE
(
    @CURRENTAPPUSERID uniqueidentifier
)
as

set nocount on;

-- Maximum number of sites to display for mobile per design

declare @MAXSITES tinyint = 50;

declare @SITESFORUSER table
(
    VALUE uniqueidentifier,
    LABEL nvarchar(250)
);

insert into @SITESFORUSER
select
    [SFU].SITEID as VALUE,
    SITE.NAME as LABEL
from 
    dbo.SITE
    inner join dbo.UFN_SITESFORUSER(@CURRENTAPPUSERID) as [SFU] on [SFU].SITEID = SITE.ID
order by 
    SITE.NAME;

if (select count(*) from @SITESFORUSER) > @MAXSITES
begin

    -- if too many sites, use default site if there is one, otherwise return nothing

    select
        SITE.VALUE,
        SITE.LABEL
    from
        dbo.APPUSER
        inner join @SITESFORUSER as SITE on SITE.VALUE = APPUSER.SITEID
    where
        APPUSER.ID = @CURRENTAPPUSERID;

end
else
begin

    select
        VALUE,
        LABEL
    from
        @SITESFORUSER;

end