UFN_COMBINATION_GETMEMBERSHIPPROGRAMS

This function returns combination membership programs and level given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_COMBINATION_GETMEMBERSHIPPROGRAMS
    (
      @COMBINATIONID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        MEMBERSHIPPROGRAMID,
            MEMBERSHIPLEVELID,
        SEQUENCE
            from
                dbo.COMBINATIONMEMBER
            where
                COMBINATIONID=@COMBINATIONID;