UFN_CONSTITUENT_GETLATESTMEMBERSHIPEXPIRATIONDATE

      CREATE function dbo.UFN_CONSTITUENT_GETLATESTMEMBERSHIPEXPIRATIONDATE(@CONSTITUENTID uniqueidentifier)
      returns datetime
      with execute as caller
      as begin
          declare @LATESTEXPIRATIONDATE datetime;

        set @LATESTEXPIRATIONDATE = 
        (
          select top(1) EXPIRATIONDATE 
          from dbo.MEMBERSHIP as MS
          inner join dbo.MEMBER as M on M.MEMBERSHIPID = MS.ID
          where M.CONSTITUENTID = @CONSTITUENTID and MS.STATUSCODE = 0
          order by EXPIRATIONDATE desc
        )

          return @LATESTEXPIRATIONDATE
      end