USP_DATALIST_SOLICITCODECHANNELOPTOUT

create procedure dbo.USP_DATALIST_SOLICITCODECHANNELOPTOUT
(
    @CONSTITUENTID uniqueidentifier
)
as
    set nocount on;

select    SOLICITCODECHANNELOPTOUT.ID,
        SOLICITCODECHANNELCODE,
        CONSENTCODE,
        STARTDATE,
        DATAPROTECTIONEVIDENCESOURCECODE.DESCRIPTION as SOURCECODE,
        COMMENTS
from    dbo.SOLICITCODECHANNELOPTOUT
join    dbo.DATAPROTECTIONEVIDENCESOURCECODE ON DATAPROTECTIONEVIDENCESOURCECODE.ID = SOURCECODEID
where    SOLICITCODECHANNELOPTOUT.CONSTITUENTID = @CONSTITUENTID
order by
    STARTDATE DESC;