USP_DATALIST_SITEIMAGES_FOR_FAF

CREATE procedure dbo.USP_DATALIST_SITEIMAGES_FOR_FAF
  (    @CONSTITUENTID uniqueidentifier = null, 
        @TYPECODE int = -1, 
    @SITEIMAGESID int = null,
    @ISPRIVATE bit = null,
    @ISADMIN bit = null
    )with execute as caller
as
    set nocount on;


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


  set @script = 
    'select 
        six.[ID] as SITEIMAGESEXTENSIONID, 
        six.[SITEIMAGESID],
        si.[CLIENTSITESID],
        si.[NAME], 
        si.[OWNERID], 
        IsNull(fpg.CAPTION, si.[CAPTION]),
        six.[CONSTITUENTID], 
        six.[TYPECODE],
        six.[TYPE],
        si.[PRIVATE],
        si.[DELETED],
        si.[APPROVED], 
        si.[GUID],
        si.[IMAGECONTENT]
  from SITEIMAGES si, SITEIMAGESEXTENSION six 
  LEFT OUTER JOIN FAFPARTICIPANTGALLERYIMAGES FPG ON FPG.SITEIMAGESID = six.siteimagesid 
  where si.ID = six.siteimagesid 
        and six.CONSTITUENTID = @CONSTITUENTID 
        and si.DELETED = 0 '

        IF @SITEIMAGESID IS NOT NULL
              set @script = @script + ' AND SITEIMAGESID = @SITEIMAGESID'

        IF @TYPECODE > -1
              set @script = @script + ' AND TYPECODE = @TYPECODE'

            IF @ISPRIVATE IS NOT NULL
              set @script = @script + ' AND PRIVATE = @ISPRIVATE'

  SET @PARAMDEF = '@CONSTITUENTID uniqueidentifier = null, @TYPECODE int = -1, @SITEIMAGESID int = null, @ISPRIVATE bit = null, @ISADMIN bit = null' 
    exec sp_executesql @script, @PARAMDEF, @CONSTITUENTID, @TYPECODE, @SITEIMAGESID, @ISPRIVATE, @ISADMIN