USP_DATALIST_CONSTITUENT_CLIENTUSER

  CREATE procedure dbo.USP_DATALIST_CONSTITUENT_CLIENTUSER
  (@CONSTITUENTID uniqueidentifier = null,
   @CLIENTUSERSID int = null
  )
  as
      set nocount on;

     select CU.ID as CLIENTUSERSID,
          C.ID as CONSTITUENTID
   from dbo.CONSTITUENT C(nolock)  
   inner join dbo.BackOfficeSystemPeople BOSP(nolock)  
    on BOSP.BackofficeRecordID = C.SEQUENCEID and BOSP.BackOfficeSystemID = 0   
   inner join dbo.BackOfficeSystemUsers BOSU(nolock)  
    on BOSU.BackofficePeopleID = BOSP.ID and BOSU.[CURRENT] = 1  
   inner join dbo.ClientUsers CU(nolock)  
    on CU.ID = bosu.ClientUsersID and CU.Deleted = 0  
   WHERE C.ID = ISNULL(@CONSTITUENTID,C.ID)
   AND CU.ID = ISNULL(@CLIENTUSERSID,CU.ID)