USP_INDIVIDUAL_LOAD

CREATE procedure dbo.USP_INDIVIDUAL_LOAD
(
  @ID uniqueidentifier
)
as
    set nocount on;

  select c.FIRSTNAME, c.KEYNAME, c.MIDDLENAME, c.TITLECODEID, c.SUFFIXCODEID, c.NICKNAME,
    c.MAIDENNAME, c.BIRTHDATE, c.GENDERCODE, c.MARITALSTATUSCODEID, c.WEBADDRESS, 
    oa.ADDRESSTYPECODEID, oa.DONOTMAIL, oa.COUNTRYID, oa.STATEID, oa.ADDRESSBLOCK, oa.CITY, oa.POSTCODE, oa.DONOTMAILREASONCODEID,
    op.PHONETYPECODEID, op.NUMBER, oe.EMAILADDRESS, u.ID as CLIENTUSERID, u.UserName,
  u.[Password], op.ID as PHONEID, oa.ID as ADDRESSID, oe.ID as EMAILADDRESSID
  from dbo.constituent (nolock) c
  left outer join dbo.[ADDRESS] (nolock) oa on oa.CONSTITUENTID = c.ID and oa.ISPRIMARY = 1
  left outer join dbo.PHONE (nolock) op on op.CONSTITUENTID = c.ID and op.ISPRIMARY = 1
  left outer join dbo.EMAILADDRESS (nolock) oe on oe.CONSTITUENTID = c.ID and oe.ISPRIMARY = 1
  left outer join dbo.CLIENTUSERS (nolock) u on u.ID = dbo.UFN_CLIENTUSERID_GET_BY_CONSTITUENT(@ID)
  where c.ID = @ID