INSERT INTO BO_CRM_CLIENT_SERDPT
(ID,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH)
SELECT BO_CRM_CLIENT_SERDPT_SEQ.NEXTVAL,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
(SELECT DEPARTMENTNAME FROM ORGDEPARTMENT WHERE ID = BMID) BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM (SELECT ORGNO,
BINDID,
SYSDATE CREATEDATE,
'admin' CREATEUSER,
SYSDATE UPDATEDATE,
'admin' UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
(CASE BMID
WHEN CAST('7880' AS NVARCHAR2(100)) THEN
CAST('51876' AS NVARCHAR2(100))
WHEN CAST('7882' AS NVARCHAR2(100)) THEN
CAST('51889' AS NVARCHAR2(100))
WHEN CAST('7879' AS NVARCHAR2(100)) THEN
CAST('51893' AS NVARCHAR2(100))
WHEN CAST('7881' AS NVARCHAR2(100)) THEN
CAST('51903' AS NVARCHAR2(100))
WHEN CAST('45807' AS NVARCHAR2(100)) THEN
CAST('51907' AS NVARCHAR2(100))
WHEN CAST('32809' AS NVARCHAR2(100)) THEN
CAST('51937' AS NVARCHAR2(100))
WHEN CAST('46837' AS NVARCHAR2(100)) THEN
CAST('51942' AS NVARCHAR2(100))
WHEN CAST('45790' AS NVARCHAR2(100)) THEN
CAST('51950' AS NVARCHAR2(100))
WHEN CAST('45762' AS NVARCHAR2(100)) THEN
CAST('51963' AS NVARCHAR2(100))
WHEN CAST('45764' AS NVARCHAR2(100)) THEN
CAST('51970' AS NVARCHAR2(100))
WHEN CAST('45760' AS NVARCHAR2(100)) THEN
CAST('51979' AS NVARCHAR2(100))
WHEN CAST('45768' AS NVARCHAR2(100)) THEN
CAST('51995' AS NVARCHAR2(100))
WHEN CAST('45784' AS NVARCHAR2(100)) THEN
CAST('52002' AS NVARCHAR2(100))
WHEN CAST('45786' AS NVARCHAR2(100)) THEN
CAST('52014' AS NVARCHAR2(100))
WHEN CAST('45782' AS NVARCHAR2(100)) THEN
CAST('52022' AS NVARCHAR2(100))
WHEN CAST('7896' AS NVARCHAR2(100)) THEN
CAST('52004' AS NVARCHAR2(100))
WHEN CAST('7895' AS NVARCHAR2(100)) THEN
CAST('52016' AS NVARCHAR2(100))
WHEN CAST('45772' AS NVARCHAR2(100)) THEN
CAST('51904' AS NVARCHAR2(100))
WHEN CAST('45774' AS NVARCHAR2(100)) THEN
CAST('51911' AS NVARCHAR2(100))
WHEN CAST('45776' AS NVARCHAR2(100)) THEN
CAST('51917' AS NVARCHAR2(100))
WHEN CAST('45778' AS NVARCHAR2(100)) THEN
CAST('51921' AS NVARCHAR2(100))
WHEN CAST('45770' AS NVARCHAR2(100)) THEN
CAST('51931' AS NVARCHAR2(100))
WHEN CAST('45788' AS NVARCHAR2(100)) THEN
CAST('51936' AS NVARCHAR2(100))
WHEN CAST('7911' AS NVARCHAR2(100)) THEN
CAST('51877' AS NVARCHAR2(100))
WHEN CAST('32811' AS NVARCHAR2(100)) THEN
CAST('51879' AS NVARCHAR2(100))
WHEN CAST('32810' AS NVARCHAR2(100)) THEN
CAST('51880' AS NVARCHAR2(100))
WHEN CAST('45780' AS NVARCHAR2(100)) THEN
CAST('51882' AS NVARCHAR2(100))
WHEN CAST('46601' AS NVARCHAR2(100)) THEN
CAST('52032' AS NVARCHAR2(100))
END) BMID,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM BO_CRM_CLIENT_SERDPT
WHERE BMID IN (7880,
7882,
7879,
7881,
45807,
32809,
46837,
45790,
45762,
45764,
45760,
45768,
45784,
45786,
45782,
7896,
7895,
45772,
45774,
45776,
45778,
45770,
45788,
7911,
32811,
32810,
45780,
46601));
根据已知查询插入到某表的sql写法
最新推荐文章于 2024-01-18 14:18:57 发布