UFN_CONSTITUENT_GETEARLIESTMEMBERSHIPJOINDATE

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

        set @EARLIESTJOINDATE = 
        (
          select top(1) JOINDATE 
          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 JOINDATE asc
        )

          return @EARLIESTJOINDATE
      end