USP_DATALIST_MEMBERSHIPPROGRAMBENEFITS

CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMBENEFITS(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    SELECT
    ML.NAME MEMBERSHIPLEVELNAME,
    ML.ID MEMBERSHIPLEVELID
  FROM dbo.MEMBERSHIPPROGRAM MP
  INNER JOIN dbo.MEMBERSHIPLEVEL ML on MP.ID = ML.MEMBERSHIPPROGRAMID
  WHERE MP.ID = @CONTEXTID and ML.ISACTIVE = 1
  ORDER BY ML.SEQUENCE