Many thanks bit I still get and error...
Below revised statement as per your suggestion...
DECLARE @newProjectId bigint
INSERT INTO ProjectControl (ProjectId,InlcudeInForecast,ProjectCompleted,BudgetValue,ActualValue,BudgetHours,ActualHours,BillingValue,IsProspect)
VALUES
(@newProjectId,1,0,0,0,0,0,0,0)
SELECT @newProjectId,project.Id
FROM project
LEFT JOIN ProjectControl ON ProjectControl.ProjectId = project.id
WHERE...