查出来需求 select * from td.req where rq_father_id<>'-1' and RQ_NO_OF_SONS='0' order by rq_req_date,rq_req_time
因为我们的人为了省事,需求的标题当内容用了,而在缺陷中,标题是标题,内容是内容, 所以,要这样处理一下:
select left(RQ_REQ_NAME,20)+'(内详)',RQ_REQ_NAME, * from td.req where rq_father_id<>'-1' and RQ_NO_OF_SONS='0' order by rq_req_date,rq_req_time
检查了一遍,查出来的记录,没什么问题。
SQL语句如下:
insert into td.BUG (BG_BUG_ID,BG_STATUS,BG_RESPONSIBLE,BG_SUMMARY,BG_DESCRIPTION,BG_REPRODUCIBLE,BG_SEVERITY,BG_PRIORITY,BG_DETECTED_BY,BG_DETECTION_DATE,BG_TO_MAIL,BG_USER_01,BG_VTS)
select RQ_REQ_ID,'Open','wanjx',left(RQ_REQ_NAME,20)+'(内详)',RQ_REQ_NAME,'Y','2-Medium','2-Medium',RQ_REQ_AUTHOR,RQ_REQ_DATE,'Y','CLASS',RQ_VTS
from td.req
where rq_father_id<>'-1' and RQ_NO_OF_SONS='0'
order by rq_req_date,rq_req_time