— \u76ee\u7684\u5c06 AM8\u6570\u636e\u5e93\u8868\u7684\u597d\u53cb\uff0c\u8f6c\u5165\u5230 OIOrg\u8868\uff0c\u8fd9\u4e2asql \u9700\u8981\u5728 oiorg \u8868\u73af\u5883\u4e0b\u8fd0\u884c\u00a0 \uff08\u5148\u5728am8\u6570\u636e\u5e93\u8fd0\u884c\u540c\u540d\uff09<\/div>\n

— \u5f97\u5230\u7528\u6237\u6240\u6709\u5206\u7ec4\uff0c\u5206\u7ec4\u6210\u5458\u7248\u672c\u521d\u59cb\u4e3a 1<\/strong><\/div>\n
INSERT INTO OI_ORG_CONTACT_GROUP ( S_OWNER, G_ID, S_NAME, N_MEMBER_VER )<\/div>\n
SELECT c.S_OWNER, c.G_GROUPID, g.S_NAME, 1<\/div>\n
FROM [AM8].[dbo].[OI_STK_CUSTOMVIEW] c<\/div>\n
INNER JOIN [AM8].[dbo].[OI_STK_CUSTOMGROUP] g ON g.G_GROUP = c.G_GROUPID<\/div>\n
GROUP BY c.S_OWNER, c.G_GROUPID, g.S_NAME<\/div>\n
ORDER BY c.S_OWNER, c.G_GROUPID<\/div>\n
<\/div>\n
— \u5f97\u5230\u6240\u6709\u7528\u6237\u8054\u7cfb\u4eba\uff0c\u4f1a\u8fc7\u6ee4\u6389\u6240\u5728\u5206\u7ec4\u5df2\u7ecf\u6ca1\u6709\u7684\u6570\u636e<\/strong><\/div>\n
INSERT INTO OI_ORG_CONTACT ( S_OWNER, S_USER_LOGIN, G_GROUP_ID )<\/div>\n
SELECT c.S_OWNER, c.S_USERLOGIN, c.G_GROUPID<\/div>\n
FROM [AM8].[dbo].[OI_STK_CUSTOMVIEW] c<\/div>\n
WHERE c.S_USERLOGIN <> ”<\/div>\n
AND (G_GROUPID IN ( Select G_GROUP From [AM8].[dbo].[OI_STK_CUSTOMGROUP] )<\/div>\n
ORG_GROUPID = ‘{00000000-0000-0000-0000-000000000000}’ )<\/div>\n
ORDER BY c.S_OWNER, c.G_GROUPID, c.S_USERLOGIN<\/div>\n
<\/div>\n
— \u5f97\u5230\u4eba\u5458\u7684\u8054\u7cfb\u4eba\u7248\u672c\u53f7<\/div>\n
UPDATE OI_ORG_T008 SET N_C41 = b.N_VER<\/div>\n
FROM ( SELECT S_OWNER, Max( N_VER ) AS N_VER<\/div>\n
\u00a0 FROM [AM8].[dbo].[OI_STK_CUSTOMVIEW]<\/div>\n
\u00a0 GROUP BY S_OWNER ) b<\/div>\n
WHERE S_C1 = b.S_OWNER<\/div>\n
<\/div>\n
— \u4eba\u5458\u7684\u8054\u7cfb\u4eba\u5206\u7ec4\u7248\u672c\u53f7\uff0c\u6709\u5206\u7ec4\u5c31\u7f6e 1<\/div>\n
UPDATE OI_ORG_T008 SET N_C42 = 1 WHERE S_C1 IN ( Select S_OWNER From OI_ORG_CONTACT_GROUP )<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
— \u6e05\u9664 AM8 \u6570\u636e\u8868\u4e2d\u7684 \u8054\u7cfb\u4eba \u6570\u636e<\/div>\n
— TRUNCATE TABLE [AM8].[dbo].[OI_STK_CUSTOMVIEW]<\/div>\n
— GO<\/div>\n
— TRUNCATE TABLE [AM8].[dbo].[OI_STK_CUSTOMGROUP]<\/div>\n
— GO<\/div>\n","protected":false},"excerpt":{"rendered":"
— \u76ee\u7684\u5c06 AM8\u6570\u636e\u5e93\u8868\u7684\u597d\u53cb\uff0c\u8f6c\u5165\u5230 OIOrg\u8868\uff0c\u8fd9\u4e2asql \u9700\u8981\u5728 oiorg \u8868\u73af\u5883\u4e0b\u8fd0 […]<\/p>\n","protected":false},"author":1,"featured_media":891,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,2],"tags":[16,15],"class_list":["post-934","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ercikf","category-pcenter","tag-shouce","tag-sql"],"_links":{"self":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/comments?post=934"}],"version-history":[{"count":1,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/934\/revisions"}],"predecessor-version":[{"id":935,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/posts\/934\/revisions\/935"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media\/891"}],"wp:attachment":[{"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/media?parent=934"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/categories?post=934"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.haoht.com.cn\/wp-json\/wp\/v2\/tags?post=934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}