UFN_SMARTQUERY_MEMBERSHIPMAILINGPREFERENCE

Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@MAILINGPREFERENCE	int	IN
@INCLUDENOPREFERENCE	bit	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@MAXROWS	int	IN
Definition

Copy


        CREATE function dbo.[UFN_SMARTQUERY_MEMBERSHIPMAILINGPREFERENCE]
                (
                    @MEMBERSHIPPROGRAMID uniqueidentifier
                    , @MAILINGPREFERENCE int
                    , @INCLUDENOPREFERENCE bit
                    , @CURRENTAPPUSERID uniqueidentifier = null
                    , @MAXROWS int
                )
        returns @MEMBERSHIPS table 
                (
                    ID uniqueidentifier,    
                    CONSTITUENTID uniqueidentifier,
                    MEMBERNAME nvarchar(154), 
                    MEMBERSHIPPROGRAMNAME nvarchar(100),
                    MEMBERSHIPLEVELNAME nvarchar(100),
                    EXPIRATIONDATE datetime,
                    STATUS nvarchar(9),
                    TYPE nvarchar(50),
                    TIER nvarchar(100),
                    TERM nvarchar(8)
                )
        as
        begin
          insert into @MEMBERSHIPS
          select 
            ID    
                      , CONSTITUENTID 
                      , MEMBERNAME 
                      , MEMBERSHIPPROGRAMNAME
                      , MEMBERSHIPLEVELNAME 
                      , EXPIRATIONDATE 
                      , STATUS 
                      , TYPE 
                      , TIER 
                      , TERM
          from dbo.UFN_SMARTQUERY_MEMBERSHIPMAILINGPREFERENCE_2(
            @MEMBERSHIPPROGRAMID
            , @MAILINGPREFERENCE
                      , @INCLUDENOPREFERENCE
                      , null
                      , @CURRENTAPPUSERID
                      , @MAXROWS);

          return;
        end