请教SQL insert into问题

[iazou]

COMPANY CREATOR DATE MF001 MF002 MF003
TEST 3100 20080428 T1012 107 200
TEST 3100 20090209 T1012 122 200
TEST 3100 20090918 T0027 101 0
TEST 3100 20080428 T0027 103 200
TEST 3100 20080428 T0027 104 200
TEST 3100 20080428 T0047 103 200
TEST 3100 20080428 T0047 104 200
TEST 3100 20090918 T0074 101 200
TEST 3100 20080428 T0074 103 200
TEST 3100 20080428 T0074 104 200
TEST 3100 20080428 T0080 103 200
TEST 3100 20080428 T0080 104 100
TEST 3100 20090209 T0080 122 200
TEST 3100 20090209 T0080 201 200
TEST 3100 20080428 T3085 103 50
TEST 3100 20090209 T3085 209 20

表结构如上 (MF001=员工代号，MF002=项目代号，MF003=金额)
insert into test..YPAMF
(COMPANY, CREATOR, DATE, MF001,MF002, MF003)
values
('TEST', '3100', '20090918','T0027','101','0')

以上对单个员工这样插入一项数据。如果我要对所有员工插入项目代号为101 金额为5 要怎么写insert语句？

[华夏小卒]

insert into test..YPAMF 
  (COMPANY, CREATOR, DATE,  MF001,MF002, MF003) 
select max('TEST'),max('3100'),max('20090918'),MF001,max('101'),max('5')
 from test..YPAMF group by MF001

--try

[xiequan2]

insert into test..YPAMF select distinct COMPANY ,CREATOR ,'20090918',MF001,'101', 5 from tb

[--小F--]

insert into a(.....) select .... from b 
或者
select ... into b from a

[lihan6415151528]

insert into a
select ... from b

[spsx99vj]

insert into test..YPAMF
(...,MF002, MF003)
select ...,'101','5'

[iazou]

[Quote=引用 1 楼 js_szy 的回复:]
SQL codeinsertinto test..YPAMF
(COMPANY, CREATOR, DATE, MF001,MF002, MF003)selectmax('TEST'),max('3100'),max('20090918'),MF001,max('101'),max('5')from test..YPAMFgroupby MF001--try
[/Quote]

不行呢？
提示错误
服务器: 消息 2627，级别 14，状态 1，行 1
Violation of PRIMARY KEY constraint 'PK_YPAMF'. Cannot insert duplicate key in object 'YPAMF'.
The statement has been terminated.

[cyun1205]

主键冲突，违反PRIMARY KEY约束'PK_YPAMF'，不能插入对象'重复键YPAMF'。