USP_DATALIST_TEAMFAF

Returns all TeamFaf records.

Definition

Copy


create procedure dbo.USP_DATALIST_TEAMFAF
as
    set nocount on;

    select 
        TEAMFAF.[ID],
        TEAMFAF.[TEAMFUNDRAISINGTEAMID],
        TEAMFAF.[TEAMMASTERID],
        TEAMFAF.[EVENTID],
        TEAMFAF.[CONSTITUENTID],
        TEAMFAF.[ADDRESSID],
        TEAMFAF.[TEAMLEVELID],
        TEAMFAF.[TEAMGROUPID],
        TEAMFAF.[TEAMTYPEID],
        TEAMFAF.[TEAMNAME],
        TEAMFAF.[TEAMDESCRIPTION],
        TEAMFAF.[IMAGEID],
        TEAMFAF.[PHONE],
        TEAMFAF.[PHONEALT],
        TEAMFAF.[FAX],
        TEAMFAF.[PRIMARYPHOTO],
        TEAMFAF.[SECONDARYPHOTO]
    from 
        dbo.TEAMFAF