UFN_SMARTQUERY_GETSYSTEMROLEPERMISSIONSLIST

            create function dbo.UFN_SMARTQUERY_GETSYSTEMROLEPERMISSIONSLIST
            (
                @SMARTQUERYCATALOGID uniqueidentifier
            )
            /*Returns a list of table IDs for all system roles that have permissions set for the given SMARTQUERYCATALOGID.*/
            returns table
            as 
            return
            (
                select
                    [SRP].ID,
                    [SR].NAME,
                    [SRP].SYSTEMROLEID,
                    [SRP].GRANTORDENY
                from dbo.SYSTEMROLE as [SR] 
                left join dbo.SYSTEMROLEPERM_SMARTQUERY as [SRP] on [SRP].SYSTEMROLEID = [SR].ID
                where [SRP].SMARTQUERYCATALOGID = @SMARTQUERYCATALOGID
            )