我的思路是把数据放到游标中，然后通过循环设置值，然后再把数据添加到统计表中！
但是希望大家给我的点提示或者，小例子，让做起来更方便些

create table company(company_id int,company_name nvarchar(10))
create table project(project_id int,project_name nvarchar(10),project_type nvarchar(10),own_company nvarchar(10))
insert into company select 1,'大企业'
insert into project select 1,'修铁路','铁路','大企业'
union all select 2,'做软件','软件','大企业'
union all select 3,'做贸易','贸易','大企业'
select * from project
select * from company

select b.*,company.company_id from (select project_id as 编号,project_name as 项目名称,sum(case project_type when '铁路' then 1 else 0 end ) as 项目类型一,
sum(case project_type when '软件' then 1 else 0 end ) as 项目类型二,sum(case project_type when '贸易' then 1 else 0 end ) as 项目类型三
from project p group by project_id,project_name) as b,project,company where b. 编号=project.project_id and project.own_company=company.company_name
order by 编号

哥们你真很，谢谢了，成了！

名不虚传啊！太感谢了!
我还在那想存储过程呢，呵呵，写到快翻页了，一看定义了一堆变量！呵呵，再次感谢！