USP_DATALIST_RSS_FEED

CREATE procedure dbo.USP_DATALIST_RSS_FEED
(
  @EVENTID uniqueidentifier,
  @REGISTRANTID uniqueidentifier = null,
  @TEAMFUNDRAISINGTEAMID uniqueidentifier = null,
  @TYPECODE tinyint = 0,
  @ISADMIN bit = 0
) with execute as owner
as
    set nocount on;

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

    set @script = 
    'select 
        FAFRSSFEED.[ID],
        FAFRSSFEED.[EVENTID],
        FAFRSSFEED.[REGISTRANTID],
        FAFRSSFEED.[TEAMFUNDRAISINGTEAMID],
        FAFRSSFEED.[TYPECODE],
        FAFRSSFEED.[RSSFEEDURL]
    from 
        dbo.FAFRSSFEED
    WHERE 
        FAFRSSFEED.eventid = @EVENTID
        AND FAFRSSFEED.TYPECODE = @TYPECODE'

    IF @TYPECODE = 0 AND @ISADMIN = 0
    set @script = @script + ' AND FAFRSSFEED.REGISTRANTID = ISNULL(@REGISTRANTID,''00000000-0000-0000-0000-000000000000'') '

    IF @TYPECODE IN (1,2,3) AND @ISADMIN = 0
    set @script = @script + ' AND FAFRSSFEED.TEAMFUNDRAISINGTEAMID = ISNULL(@TEAMFUNDRAISINGTEAMID,''00000000-0000-0000-0000-000000000000'') '

    IF @ISADMIN = 1
    set @script = @script + ' AND FAFRSSFEED.TEAMFUNDRAISINGTEAMID IS NULL AND FAFRSSFEED.REGISTRANTID IS NULL '    

    SET @PARAMDEF = '@EVENTID uniqueidentifier, @REGISTRANTID uniqueidentifier = null, @TEAMFUNDRAISINGTEAMID uniqueidentifier = null, @TYPECODE tinyint = 0, @ISADMIN bit = 0'

    exec sp_executesql @script, @PARAMDEF, @EVENTID,@REGISTRANTID,@TEAMFUNDRAISINGTEAMID,@TYPECODE,@ISADMIN