UFN_APPEALMAILINGSETUP_GETSELECTIONS

Returns all selections for a given appeal mailing setup.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@APPEALMAILINGSETUPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_APPEALMAILINGSETUP_GETSELECTIONS
(
    @APPEALMAILINGSETUPID uniqueidentifier
) returns table as
    return (
        select
            APPEALMAILINGSETUPSELECTION.ID,
            APPEALMAILINGSETUPSELECTION.SELECTIONID,
      IDSETREGISTER.NAME as SELECTIONLABEL
        from
            dbo.APPEALMAILINGSETUPSELECTION
      inner join dbo.IDSETREGISTER on IDSETREGISTER.ID = APPEALMAILINGSETUPSELECTION.SELECTIONID
        where
            APPEALMAILINGSETUPSELECTION.APPEALMAILINGSETUPID = @APPEALMAILINGSETUPID
        );