USP_DATALIST_CONSTITUENTMEMBERSHIPCOMMENTS

        CREATE procedure dbo.USP_DATALIST_CONSTITUENTMEMBERSHIPCOMMENTS
        (
          @MEMBERSHIPID uniqueidentifier
        )
        as
          set nocount on;

          select
            MEMBERSHIP.ID,
            0 as NOTETYPE,
            'Membership' as TYPE,
            NULL as DATE,
            MEMBERSHIP.COMMENTS
          from dbo.MEMBERSHIP
            inner join dbo.MEMBER on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID
          where
            MEMBERSHIP.ID = @MEMBERSHIPID and
            MEMBER.ISPRIMARY = 1 and
            MEMBERSHIP.COMMENTS <> ''

          union all

          select
            MEMBERSHIPTRANSACTION.ID,
            1 as NOTETYPE,
            'Transaction' as TYPE,
            MEMBERSHIPTRANSACTION.TRANSACTIONDATE,
            MEMBERSHIPTRANSACTION.COMMENTS
          from dbo.MEMBERSHIP
            inner join dbo.MEMBERSHIPTRANSACTION on MEMBERSHIP.ID = MEMBERSHIPTRANSACTION.MEMBERSHIPID
            inner join dbo.MEMBER on MEMBER.MEMBERSHIPID = MEMBERSHIP.ID
          where
            MEMBERSHIP.ID = @MEMBERSHIPID and
            MEMBER.ISPRIMARY = 1 and
            MEMBERSHIPTRANSACTION.COMMENTS <> ''
          order by NOTETYPE asc, DATE desc;