如何编程把以下temp表变成tmep1表，请各位老师指导、赐教，感谢。
CLOSE ALL
CLEAR
SET SAFETY off
SET CENTURY on
SET DATE TO ansi
CREATE table temp(cname c (8),code1 c(8), code2 c(4),amount n (9,2),date1 d(12),date2 d(12))
INSERT INTO temp VALUES ( "amy","0101","A",143.59,{^2000-09-01},{^2000-09-30})
INSERT INTO temp VALUES ( "amy","0101","B",47.86,{^2000-09-01},{^2000-09-30})
INSERT INTO temp VALUES ( "amy","0101","A",420.00,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "amy","0101","B",140.00,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "amy","0101","A",380.00,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "amy","0101","B",138.00,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "amy","0101","A",290.00,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "amy","0101","B",136.00,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "amy","0101","A",390.00,{^2001-01-01},{^2001-01-31})
INSERT INTO temp VALUES ( "amy","0101","B",138.00,{^2001-01-01},{^2001-01-31})
INSERT INTO temp VALUES ( "amy","0305","A",158.92,{^2000-08-01},{^2000-08-31})
INSERT INTO temp VALUES ( "amy","0305","B",69.71,{^2000-08-01},{^2000-08-31})
INSERT INTO temp VALUES ( "amy","0305","A",168.85,{^2000-09-01},{^2000-09-30})
INSERT INTO temp VALUES ( "amy","0305","B",58.92,{^2000-09-01},{^2000-09-30})
INSERT INTO temp VALUES ( "amy","0305","A",380.52,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "amy","0305","B",128.52,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "amy","0305","A",321.01,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "amy","0305","B",125.52,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "amy","0305","A",252.85,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "amy","0305","B",105.92,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "cici","0201","A",585.00,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "cici","0201","B",158.00,{^2000-10-01},{^2000-10-31})
INSERT INTO temp VALUES ( "cici","0201","A",250.00,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "cici","0201","B",163.50,{^2000-11-01},{^2000-11-30})
INSERT INTO temp VALUES ( "cici","0201","A",212.00,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "cici","0201","B",105.00,{^2000-12-01},{^2000-12-31})
INSERT INTO temp VALUES ( "cici","0201","A",385.00,{^2001-01-01},{^2001-01-31})
INSERT INTO temp VALUES ( "cici","0201","B",125.00,{^2001-01-01},{^2001-01-31})
INSERT INTO temp VALUES ( "cici","0201","A",141.59,{^2001-02-01},{^2001-02-28})
INSERT INTO temp VALUES ( "cici","0201","B",49.86,{^2001-02-01},{^2001-02-28})