Is it possible to insert a unique id with sum() I have a 2 sproc first sproc go something like this. Code: declare @p_Project_ID int, @Indentity1 int insert into Projects(Project_ID, ProjectName, ProjectNumber) [EMAIL][email protected]@Identity(Project_id);store[/EMAIL] it in local values(52, 'MEDical start1', '5465464546541') set @p_Project_ID = @@IDENTITY insert into PersonnelSummary (Date, Cleveland_Resident, DailyWork, Employee_Name, Gender, Minority, Position, Present, SubContractor, Project_ID, TradeContractor) values (04/02/2010, 1, 'woking', 'testing', 'male', 'yes', 'woking', 1, 'shelyb', @@IDENTITY, 'shelby') insert into Narrative (Date, ContructionManager, Location, MonitorSummary, MIM, MIF, MAF, MAM, Project_ID) Values (04/02/2010, 'tomas', 'cmc', 'testing1', 4,5,4,5, @p_Project_ID) second Code: insert into dbo.Manpower(Minority_Employees, Female_Employees, Total_Employees, Cleveland_Residents) Select SUM(Narrative.MIM),Sum(Narrative.MIF), SUM(Narrative.MAF + Narrative.MAM + Narrative.MIF + Narrative.MIM), SUM(PersonnelSummary.Cleveland_Resident) from Narrative, PersonnelSummary which displays in show table page. The problem I have a Project_ID int not null column in all the tables. The first one insert the Project_ID in all the tables it works perfectly except when it the same id i get an error. I need for it to place the Project_ID from the Narrative.Project_ID into the Manpower.Manpower_ID Please if you can not give me an example don't respond to the plea for help. I work off example. which displays in show table page. The problem I have a Project_ID int not null column in all the tables. The first one insert the Project_ID in all the tables it works perfectly except when it the same id i get an error.