USP_DATALIST_GETINDIVIDUALDETAIL

CREATE procedure dbo.USP_DATALIST_GETINDIVIDUALDETAIL
(@CONSTITUENTID  uniqueidentifier)
as
    set nocount on;

    select  CONSTITUENT.ID, 
          CONSTITUENT.FIRSTNAME,
          CONSTITUENT.KEYNAME,
          ADDRESS.ADDRESSBLOCK [ADDRESS], 
          ADDRESS.CITY, 
          ADDRESS.STATEID [STATE], 
          ADDRESS.POSTCODE,
          EMAILADDRESS.EMAILADDRESS
 from dbo.CONSTITUENT 
 left join dbo.ADDRESS with (nolock) on CONSTITUENT.ID = ADDRESS.CONSTITUENTID and ADDRESS.ISPRIMARY = 1
 left join dbo.EMAILADDRESS on EMAILADDRESS.CONSTITUENTID = CONSTITUENT.ID and EMAILADDRESS.ISPRIMARY = 1
 where CONSTITUENT.ID = @CONSTITUENTID
 and CONSTITUENT.ISCONSTITUENT = 1
 and not exists (select top 1 ID from dbo.DECEASEDCONSTITUENT with (nolock) where DECEASEDCONSTITUENT.ID = CONSTITUENT.ID)
 and CONSTITUENT.ISORGANIZATION = 0
 and CONSTITUENT.ISGROUP = 0
 and CONSTITUENT.ISINACTIVE = 0