UFN_CONSTITUENTUPDATEBATCH_GETSOLICITCODES

create function dbo.UFN_CONSTITUENTUPDATEBATCH_GETSOLICITCODES
(
@BATCHCONSTITUENTUPDATEID uniqueidentifier
)
returns table
as
return
(
select
    ID,
    CONSTITUENTSOLICITCODEID,
    SOLICITCODEID,
    STARTDATE,
    ENDDATE,
    COMMENTS,
    SEQUENCE,
    CONSENTPREFERENCECODE,
    SOURCECODEID,
    SOURCEFILEPATH,
    PRIVACYPOLICYFILEPATH,
    SUPPORTINGINFORMATION,
    CONSENTSTATEMENT
from 
    dbo.BATCHCONSTITUENTUPDATESOLICITCODE
where 
    BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
)