INSERT INTO FlyPM_PrjPlan_Task
(PT_ID, PP_ID, Wbs_ID, PT_DepartID, PT_Status, PT_EntrustDate,
PT_PlanEnd, PT_ControlRe, PT_Re, PT_Editor, PT_EditTime,
PT_IsNewAdd, PT_IsDelete, PT_AddDelTime)
SELECT
'2014030500002', '20140305002', '1408', sDeptID, sWbsStatus,
dEntrustDate, dPlanEndDate, sControlRe, sRe, sCreater,
dCreateTime, '1', '0', GETDATE()
FROM
FlyPM_WbsItem
WHERE
Wbs_ID='1408'
(PT_ID, PP_ID, Wbs_ID, PT_DepartID, PT_Status, PT_EntrustDate,
PT_PlanEnd, PT_ControlRe, PT_Re, PT_Editor, PT_EditTime,
PT_IsNewAdd, PT_IsDelete, PT_AddDelTime)
SELECT
'2014030500002', '20140305002', '1408', sDeptID, sWbsStatus,
dEntrustDate, dPlanEndDate, sControlRe, sRe, sCreater,
dCreateTime, '1', '0', GETDATE()
FROM
FlyPM_WbsItem
WHERE
Wbs_ID='1408'
insert into FlyPM_PrjPlan_Task
(PT_ID, PP_ID, Wbs_ID, PT_DepartID, PT_Status,
PT_EntrustDate,PT_PlanEnd, PT_ControlRe, PT_Re, PT_Editor,
PT_EditTime, PT_IsNewAdd, PT_IsDelete, PT_AddDelTime)
SELECT '2014030500002','20140305002','1408',sDeptID, sWbsStatus,
dEntrustDate, dPlanEndDate, sControlRe, sRe, sCreater,
dCreateTime,'1','0',GETDATE()
FROM FlyPM_WbsItem where Wbs_ID = '1408'
insert into FlyPM_PrjPlan_Task
(PT_ID,PP_ID,Wbs_ID,PT_DepartID,PT_Status,PT_EntrustDate,
PT_PlanEnd,PT_ControlRe,PT_Re,PT_Editor,PT_EditTime,
PT_IsNewAdd,PT_IsDelete,PT_AddDelTime)
select a.PT_ID,a.PP_ID,a.Wbs_ID,
b.sDeptID,b.sWbsStatus,b.dEntrustDate,b.dPlanEndDate,b.sControlRe,b.sRe,
b.sCreater,b.dCreateTime,
a.PT_IsNewAdd,a.PT_IsDelete,a.PT_AddDelTime
from (select '2014030500002' 'PT_ID','20140305002' 'PP_ID','1408' 'Wbs_ID','1' 'PT_IsNewAdd','0' 'PT_IsDelete',getdate() 'PT_AddDelTime') a
cross join
(select sDeptID,sWbsStatus,dEntrustDate,dPlanEndDate,sControlRe,sRe,sCreater,dCreateTime
from FlyPM_WbsItem
where Wbs_ID='1408') b