USP_DATALIST_CONSTITUENTSOLICITCODES

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

select
  CONSTITUENTSOLICITCODE.ID,
  CONSTITUENTSOLICITCODE.SOLICITCODEID,
  CONSTITUENTSOLICITCODE.STARTDATE,
  CONSTITUENTSOLICITCODE.ENDDATE,
  CONSTITUENTSOLICITCODE.COMMENTS,
  CONSTITUENTSOLICITCODE.SEQUENCE,
  CONSTITUENTSOLICITCODE.CONSENTPREFERENCECODE,
  CONSTITUENTSOLICITCODE.SOURCECODEID,
  CONSTITUENTSOLICITCODE.SOURCEFILEPATH,
  CONSTITUENTSOLICITCODE.PRIVACYPOLICYFILEPATH,
  CONSTITUENTSOLICITCODE.SUPPORTINGINFORMATION,
  CONSTITUENTSOLICITCODE.CONSENTSTATEMENT,
  SOLICITCODE.CONSENTCODE
from dbo.CONSTITUENTSOLICITCODE
  inner join dbo.SOLICITCODE on CONSTITUENTSOLICITCODE.SOLICITCODEID = SOLICITCODE.ID 
where CONSTITUENTID = @CONSTITUENTID;