UFN_WPBIOGRAPHICAL_GETHHMEMBERS

CREATE function dbo.UFN_WPBIOGRAPHICAL_GETHHMEMBERS(@WPBIOGRAPHICALDEMOGRAPHICID uniqueidentifier)
returns table
as return
  select top 5
    ID,
    WPBIOGRAPHICALDEMOGRAPHICID,
    FULLNAME,
    FIRSTNAME,
    MIDDLENAME,
    LASTNAME,
    SUFFIXCODEID,
    SUFFIX,
    BIRTHDATE,
    AGE,
    MARITALSTATUSCODEID,
    MARITALSTATUS,
    OCCUPATION,
    TITLECODEID,
    TITLE,
    SEQUENCE
  from
  dbo.WPBIOGRAPHICALHHMEMBER
  where WPBIOGRAPHICALHHMEMBER.WPBIOGRAPHICALDEMOGRAPHICID = @WPBIOGRAPHICALDEMOGRAPHICID