UFN_SYSTEMROLE_GETCODETABLEPERMISSIONS

CREATE function dbo.UFN_SYSTEMROLE_GETCODETABLEPERMISSIONS
(
    @SYSTEMROLEID uniqueidentifier
)
returns table
as
return
(
    select
        SYSTEMROLEPERM_CODETABLE.ID,
        V_INSTALLED_CODETABLECATALOG.ID as CODETABLECATALOGID,
        CODETABLECATEGORY.DESCRIPTION,
        V_INSTALLED_CODETABLECATALOG.UINAME as CODETABLENAME,                
        coalesce(SYSTEMROLEPERM_CODETABLE.ADDPERMISSIONCODE, 0) as ADDPERMISSIONCODE,
        coalesce(SYSTEMROLEPERM_CODETABLE.UPDATEPERMISSIONCODE, 0) as UPDATEPERMISSIONCODE,
        coalesce(SYSTEMROLEPERM_CODETABLE.DELETEPERMISSIONCODE, 0) as DELETEPERMISSIONCODE
    from
        dbo.V_INSTALLED_CODETABLECATALOG
    left outer join dbo.SYSTEMROLEPERM_CODETABLE
            on V_INSTALLED_CODETABLECATALOG.ID = SYSTEMROLEPERM_CODETABLE.CODETABLECATALOGID
            and SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID = @SYSTEMROLEID
    left outer join dbo.CODETABLECATEGORY
                on V_INSTALLED_CODETABLECATALOG.CATEGORYID = CODETABLECATEGORY.ID   
    where
        exists (select null from dbo.SYSTEMROLE where ID = @SYSTEMROLEID)
)