USP_ORGANIZATION_LOAD

create procedure dbo.USP_ORGANIZATION_LOAD
(
  @ID uniqueidentifier
)
as
    set nocount on;

  select c.KEYNAME, c.WEBADDRESS, oa.ADDRESSTYPECODEID, oa.DONOTMAIL, oa.COUNTRYID, oa.STATEID, oa.ADDRESSBLOCK, oa.CITY, oa.POSTCODE, oa.DONOTMAILREASONCODEID,
      op.PHONETYPECODEID, op.NUMBER, oe.EMAILADDRESS
  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
  where c.ID = @ID