Use [EnVisage]

IF EXISTS (SELECT *
           FROM   sys.objects
           WHERE  object_id = OBJECT_ID(N'[dbo].[GetFCWeekStartForDate]')
                  AND type IN ( N'FN', N'IF', N'TF', N'FS', N'FT' ))
AND
EXISTS (SELECT *
           FROM   sys.objects
           WHERE  object_id = OBJECT_ID(N'[dbo].[GetFCWeekEndForDate]')
                  AND type IN ( N'FN', N'IF', N'TF', N'FS', N'FT' ))

UPDATE PeopleResource2Team
	SET StartDate = [dbo].GetFCWeekStartForDate(A.StartDate),
	EndDate = [dbo].GetFCWeekEndForDate(A.EndDate)
from PeopleResource2Team A
inner join PeopleResource B ON (A.PeopleResourceId = B.Id) AND (A.StartDate = B.StartDate) AND (A.EndDate = B.EndDate)
GO