USP_DATALIST_FAF_PARTICIPANT_GALLERY_IMAGES

CREATE procedure dbo.USP_DATALIST_FAF_PARTICIPANT_GALLERY_IMAGES
 (    @CONSTITUENTID uniqueidentifier = null, 
        @EVENTID uniqueidentifier = null
    )with execute as caller
as
    set nocount on;

  declare @script as nvarchar(4000)
  declare @PARAMDEF as nvarchar(2000)

    set @script = '
    select 
        FAFPGI.[ID],
        FAFPGI.[CONSTITUENTID],
        FAFPGI.[EVENTID],
        FAFPGI.[SITEIMAGESID],
        FAFPGI.[NAME],
        FAFPGI.[DESCRIPTION],
        FAFPGI.[CAPTION],
        FAFPGI.[PRIVATE],
        FAFPGI.[SORTORDER],
        SI.[IMAGECONTENT]
    from 
        dbo.SITEIMAGES SI
        join dbo.FAFPARTICIPANTGALLERYIMAGES FAFPGI
        ON FAFPGI.SITEIMAGESID = SI.ID
        where CONSTITUENTID = ISNULL(@CONSTITUENTID, CONSTITUENTID) and SI.deleted = 0'

  IF @EVENTID IS NOT NULL
    set @script = @script + ' AND EVENTID = ISNULL(@EVENTID,EVENTID)'

  SET @PARAMDEF = '@CONSTITUENTID uniqueidentifier = null, @EVENTID uniqueidentifier = null'
  exec sp_executesql @script, @PARAMDEF, @CONSTITUENTID, @EVENTID