UFN_MEMBERSHIPRENEWALEFFORT_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



                create function dbo.UFN_MEMBERSHIPRENEWALEFFORT_GETNAME(@ID uniqueidentifier)
                returns nvarchar(100) 
                as
                begin
                    declare @NAME nvarchar(100);
                    select @NAME = MKTMEMBERSHIPMAILINGTEMPLATE.NAME 
                    from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE] 
                    inner join dbo.[MKTMEMBERSHIPMAILINGPROCESS] 
                        on [MKTMEMBERSHIPMAILINGPROCESS].[MEMBERSHIPMAILINGTEMPLATEID] = [MKTMEMBERSHIPMAILINGTEMPLATE].[ID]
                    where MKTMEMBERSHIPMAILINGPROCESS.ID = @ID;
                    return @NAME;
                end