spLoadRecord_FundRaiserTeams

            CREATE      PROCEDURE [dbo].[spLoadRecord_FundRaiserTeams]
            (
            @PKID int
            )
            AS

            SELECT     [ID],
            [BackOfficeID]    ,
            [FundRaiserID]     ,
            [ReportsToID]     ,
            [Name]        ,
            [CaptainID]    ,
            dbo.fnFundRaiserPageID([ID],2) [FundRaiserPageID],
            dbo.fnFundRaiserTeamGoal([ID], 0, 0) [Goal],
            [Dirty]        ,
            [Independent]

            FROM FundRaiserTeams WHERE ID = @PKID