UFN_APPUSER_GETALLSYSTEMROLES_FROMITEMLISTXML

create function dbo.UFN_APPUSER_GETALLSYSTEMROLES_FROMITEMLISTXML
(
    @SYSTEMROLES xml
)
returns table
as return (
    select
        T.c.value('(@SYSTEMROLEID)[1]','uniqueidentifier') AS 'SYSTEMROLEID',
        case 
            when T.c.value('(@SELECTED)[1]','nvarchar(5)') = 'True' then 1 
            else 0 
        end AS 'SELECTED',
        T.c.value('(@NAME)[1]','nvarchar(255)') AS 'NAME'
    from @SYSTEMROLES.nodes('/SYSTEMROLES/ITEM') T(c)
)