USP_SIMPLEDATALIST_SITESFORSPECIFICUSER

List of all sites in the system that specified user can interact with (based on Role assignments).

Parameters

Parameter	Parameter Type	Mode	Description
@SPECIFICUSERID	uniqueidentifier	IN

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_SITESFORSPECIFICUSER(@SPECIFICUSERID uniqueidentifier)

                as                

                    set nocount on;

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