spDelete_FundRaiserTeams

    CREATE     PROCEDURE [dbo].[spDelete_FundRaiserTeams]
    (
        @PKID int    ,
        @CurrentUsersID    int
    )
    AS
    begin

    begin transaction

    delete from PersonalPageData where ParentID = @PKID AND ParentType=2

    delete from FundRaiserSolicitors where TeamID = @PKID

    delete from Comments where TeamID = @PKID

    declare @TeamID integer
    declare c1 cursor local fast_forward for
        select frt.[ID] from dbo.FundRaiserTeams frt
        where frt.ReportsToID=@PKID

    open c1

    fetch next from c1 into @TeamID
    while @@FETCH_STATUS=0
    begin
        exec spDelete_FundRaiserTeams @TeamID, @CurrentUsersID
        fetch next from c1 into @TeamID
    end

    close c1
    deallocate c1

    delete from FundRaiserTeams where [ID]=@PKID

    commit transaction

    end