UFN_MEMBERSHIPDUESBATCH_GETSOLICITCODES

create function dbo.UFN_MEMBERSHIPDUESBATCH_GETSOLICITCODES
(
  @BATCHMEMBERSHIPDUESID uniqueidentifier
)
returns table
as
return
(
  select
    ID,
    CONSTITUENTSOLICITCODEID,
    SOLICITCODEID,
    STARTDATE,
    ENDDATE,
    coalesce(COMMENTS,'') as COMMENTS,
    SEQUENCE,
    CONSENTPREFERENCECODE,
    SOURCECODEID,
    SOURCEFILEPATH,
    PRIVACYPOLICYFILEPATH,
    SUPPORTINGINFORMATION,
    CONSENTSTATEMENT
  from dbo.BATCHMEMBERSHIPDUESSOLICITCODE
  where BATCHMEMBERSHIPDUESID = @BATCHMEMBERSHIPDUESID
)