USP_DATALIST_FAFTOPFUNDRAISERDISPLAYOPTION

CREATE procedure dbo.USP_DATALIST_FAFTOPFUNDRAISERDISPLAYOPTION
(
@EVENTID uniqueidentifier
) with execute as caller

as
    set nocount on;

    select 
        [ID],
        [EVENTID],
        [NUMBERCOMPANIESTODISPLAY],
        [DISPLAYCOMPANYNAME],
        [DISPLAYCOMPANYPICTURE],
        [DISPLAYCOMPANYSTORY],
        [DISPLAYCOMPANYTOTALRAISED],
        [DISPLAYCOMPANYFUNDRAISINGGOAL],
        [NUMBERTEAMSTODISPLAY],
        [DISPLAYTEAMNAME],
        [DISPLAYTEAMPICTURE],
        [DISPLAYTEAMSTORY],
        [DISPLAYTEAMTOTALRAISED],
        [DISPLAYTEAMFUNDRAISINGGOAL],
        [NUMBERHOUSEHOLDSTODISPLAY],
        [DISPLAYHOUSEHOLDNAME],
        [DISPLAYHOUSEHOLDPICTURE],
        [DISPLAYHOUSEHOLDSTORY],
        [DISPLAYHOUSEHOLDTOTALRAISED],
        [DISPLAYHOUSEHOLDFUNDRAISINGGOAL],
        [NUMBERPARTICIPANTSTODISPLAY],
        [DISPLAYPARTICIPANTNAME],
        [DISPLAYPARTICIPANTPICTURE],
        [DISPLAYPARTICIPANTSTORY],
        [DISPLAYPARTICIPANTTOTALRAISED],
        [DISPLAYPARTICIPANTFUNDRAISINGGOAL],
        [PLAYEROPTIONSTITLE],
        [WIDTH],
        [HEIGHT],
        [SCROLLINGDIRECTIONCODE],
        [SPEED],
        [DISPLAYPLAYPAUSEOPTIONS],

        [DISPLAYCOMPANIES], 
        [DISPLAYTEAMS], 
        [DISPLAYHOUSEHOLDS],
        [DISPLAYPARTICIPANTS], 
        [DISPLAYTEAMNAMEADDITIONFUNDRAISERNAME],
        [DISPLAYCOMPANYNAMEADDITIONFUNDRAISERNAME]

    FROM  dbo.FAFTOPFUNDRAISERDISPLAYOPTION
    WHERE EVENTID = ISNULL(@EVENTID,EVENTID)