USP_DATAFORMTEMPLATE_VIEW_WALKMESETTINGS

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WALKMESETTINGS
(
    @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ENVIRONMENTTYPE tinyint = null output,
    @USERISSYSADMIN bit = null output,
    @USERROLES xml = null output
)
as
    set nocount on;

    select 
        @DATALOADED = 1,
        @ENVIRONMENTTYPE = case
            when dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('WalkMeTesting') = 1
                then 1
            when dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('WalkMeProduction') = 1
                then 2
            else 0
        end,
        @USERISSYSADMIN = APPUSER.ISSYSADMIN
    from dbo.APPUSER
    where APPUSER.ID = @CURRENTAPPUSERID

    if @USERISSYSADMIN = 0
    begin
        set @USERROLES = (
            select  
                SYSTEMROLE.ID  
            from 
                dbo.SYSTEMROLE 
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLE.ID = SYSTEMROLEAPPUSER.SYSTEMROLEID
            where 
                SYSTEMROLEAPPUSER.APPUSERID = @CURRENTAPPUSERID  
            for
                xml raw('ITEM'),type,root('USERROLES'),BINARY BASE64
        )
    end

    return 0;