云萌主云应用官方论坛

标题: 打开存货功能提示 8156数据库错误 [打印本页]

作者: 2060yxz 时间: 2019-7-16 16:26
标题: 打开存货功能提示 8156数据库错误
打开存货功能提示 8156数据库错误多次为T指定了inventorydtto_code 这个是什么情况

作者: 王建 时间: 2019-7-19 13:54
---该脚本为通用脚本，以后遇到此类问题也可以处理，之前有缺陷，已经修复，历史数据待处理。 ---执行前先备份账套，执行后重启服务 ---删除重复的用户栏目方案

DELETE FROM Eap_ColumnSet_User WHERE id IN (SELECT r.eid FROM (SELECT Row_number() OVER( PARTITION BY eSolutionID, eUserId, eField, eIdSearchPlan ORDER BY eSolutionID, eUserId, eField, eIdSearchPlan) AS rankid, * FROM (SELECT e.SolutionID AS eSolutionID, e.UserId AS eUserId, e.Field AS efield, e.IdSearchPlan AS eIdSearchPlan, id AS eid FROM Eap_ColumnSet_User e INNER JOIN (SELECT * FROM (SELECT SolutionID, UserId, Field, IdSearchPlan, Count(*) AS y FROM Eap_ColumnSet_User GROUP BY SolutionID, UserId, Field, IdSearchPlan)a WHERE a.y > 1)b ON b.SolutionID = e.SolutionID AND b.UserId = e.UserId AND b.Field = e.Field AND b.IdSearchPlan = e.IdSearchPlan)h)r WHERE r.rankid > 1)

复制代码

---删除重复栏目方案

DELETE FROM eap_ColumnSetSolution_User WHERE id IN (SELECT r.eid FROM (SELECT Row_number() OVER( PARTITION BY eSolutionID, eUserId, eIdSearchPlan ORDER BY eSolutionID, eUserId, eIdSearchPlan) AS rankid, * FROM (SELECT e.SolutionID AS eSolutionID, e.UserId AS eUserId, e.IdSearchPlan AS eIdSearchPlan, id AS eid FROM eap_ColumnSetSolution_User e INNER JOIN (SELECT * FROM (SELECT SolutionID, UserId, IdSearchPlan, Count(*) AS y FROM eap_ColumnSetSolution_User GROUP BY SolutionID, UserId, IdSearchPlan)a WHERE a.y > 1)b ON b.SolutionID = e.SolutionID AND b.UserId = e.UserId AND b.IdSearchPlan = e.IdSearchPlan)h)r WHERE r.rankid > 1)

复制代码

官方教程是这样的
数据库脚本文件

欢迎光临云萌主云应用官方论坛 (https://yunmengzhu.com/)