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