USP_DATALIST_REGISTRANT_ROLE

CREATE procedure dbo.USP_DATALIST_REGISTRANT_ROLE
(
        @REGISTRANTID uniqueidentifier = null
)with execute as caller
as
    set nocount on;

    select 
        REGISTRANTROLE.[ID],
        REGISTRANTROLE.[REGISTRANTID],
        REGISTRANTROLE.[ROLECODE],
        REGISTRANTROLE.[ROLE]
    from 
        dbo.REGISTRANTROLE
    where
        REGISTRANTID = ISNULL(@REGISTRANTID,REGISTRANTID)