34,594
社区成员
发帖
与我相关
我的任务
分享
DELETE FROM [dbo].[101$]
WHERE [项目主数据编号] in
(SELECT [项目主数据编号] from [dbo].[101$]
GROUP BY [项目主数据编号],[往来对象代码] having sum(CAST(发生金额 as float)) =0)
DELETE FROM [dbo].[101$]
WHERE [项目主数据编号] in
(SELECT [项目主数据编号] from [dbo].[101$]
WHERE ISNUMERIC(发生金额) = 1
GROUP BY [项目主数据编号],[往来对象代码] having sum(CAST(发生金额 as float)) =0)
DELETE FROM [dbo].[101$]
WHERE [项目主数据编号] in
(SELECT [项目主数据编号] from [dbo].[101$]
GROUP BY [项目主数据编号],[往来对象代码] having sum(CAST(ISNULL(发生金额,'0') as float)) =0)
试试是不是好了,如果不是估计你这数据健康问题就大了,全角符号、全角数字、不合格字符都有可能。DECLARE @A VARCHAR (100)
SET @A='123.12'
SELECT SUM(CAST(@A AS FLOAT)) AS V1