USP_GETPREFERENCEFORREGISTRANT

create procedure USP_GETPREFERENCEFORREGISTRANT
(
    @REGISTRANTCONSTITUENTID  uniqueidentifier,
    @EVENTID  uniqueidentifier
)

as
set nocount on;
begin
    select 
        EP.NAME AS PREFERENCEOPTIONNAME,
        EP.ID PREFERENCEOPTIONID,
        EPG.ID PREFERENCEGROUPID 
    from dbo.REGISTRANT AS R 
    inner join dbo.REGISTRANTPREFERENCE as ERP on ERP.REGISTRANTID = R.ID    
    inner join dbo.EVENTPREFERENCE as EP on EP.ID =ERP.EVENTPREFERENCEID
    inner join dbo.EVENTPREFERENCEGROUP as EPG on EPG.ID = EP.EVENTPREFERENCEGROUPID
    where R.CONSTITUENTID =@REGISTRANTCONSTITUENTID  and R.EVENTID =@EVENTID
end