UFN_BATCHTEMPLATE_GETSYSTEMROLEPERMISSIONS

CREATE function UFN_BATCHTEMPLATE_GETSYSTEMROLEPERMISSIONS
(
    @BATCHTEMPLATEID as uniqueidentifier
)
returns table
as
return
(
    select
        SYSTEMROLEPERM_BATCHTEMPLATE.ID,
        SYSTEMROLE.ID as SYSTEMROLEID,
        SYSTEMROLE.NAME,
        coalesce(SYSTEMROLEPERM_BATCHTEMPLATE.GRANTORDENY, 2) as GRANTORDENY

    from
        dbo.SYSTEMROLE
        left outer join dbo.SYSTEMROLEPERM_BATCHTEMPLATE
            on SYSTEMROLE.ID = SYSTEMROLEPERM_BATCHTEMPLATE.SYSTEMROLEID
            and SYSTEMROLEPERM_BATCHTEMPLATE.BATCHTEMPLATEID = @BATCHTEMPLATEID                
)