From 58a28e1faa15f638a136fefdcfcd0b3106c1fa16 Mon Sep 17 00:00:00 2001 From: king <18310653075@163.com> Date: 星期三, 24 六月 2020 10:18:54 +0800 Subject: [PATCH] 2020-06-24 --- src/utils/utils.js | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/utils/utils.js b/src/utils/utils.js index 8042fad..80c6139 100644 --- a/src/utils/utils.js +++ b/src/utils/utils.js @@ -1171,7 +1171,7 @@ /* 鍚岀被鏁版嵁楠岃瘉 */ Set @tbid='' - Select top 1 @tbid='X' from (select distinct ${item.field},1 as n from ${datasource} inner join (select ID from dbo.SplitComma(@ID@)) sp on tb.${primaryKey}=sp.ID ) a group by ${item.field} having sum(n)>1 + Select top 1 @tbid='X' from (select distinct ${item.field},1 as n from ${datasource} inner join (select ID from dbo.SplitComma(@ID@)) sp on tb.${primaryKey}=sp.ID ) a having sum(n)>1 If @tbid!='' Begin -- Gitblit v1.8.0