Please try this stored procedure.You can use your table instead of @sourceTbl used in this sample

create procedure sptest as

begin

 DECLARE @sourceTbl TABLE (proj varchar(50),Sector varchar(50))

 DECLARE @ResultTbl TABLE (proj varchar(50),Sector...