错误代码:16389(4005H)
Source :Microsoft OLE DB Provider for SQL Server
Detail :子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。

--客户修改资料报错，安装补丁中间报错还是不行，将下面物料内码重复的删除即可，删除ftypeid=0 的

SELECT * INTO

t_BaseProperty_bak202xxxxx

from t_BaseProperty

select * from  t_BaseProperty where ftypeid=0

delete  t_BaseProperty where ftypeid=0 

是因为t_BaseProperty 这个表出现记录重复了,删除其中一条记录便可

use AIS20140120174606
go
select FPayCondition,* from t_Organization where FNumber='E0009'----1770
--update t_Organization set FPayCondition=1009 where FNumber='E0009'
--select * from t_Item where FItemClassID=1 and FNumber='E0009'
select * from t_ItemPayColCondition where FItemID=1770
update t_Organization set FPayCondition=1004 where FNumber='E0009'
update t_ItemPayColCondition set FPayColConditionID=1004 where FItemID=1770
非常感谢！解决了问题！！！:/)
解决了呢！好东西！！！
我也出现这个问题，执行这个语句后，没有效果，还是同样的错误。

delete from t_BaseProperty where FItemID in(
select FItemID from t_Organization where FItemID in(select FItemID from t_BaseProperty
where FItemID in (select FItemID from t_BaseProperty group by FItemID having count

(FItemID) > 1) and FTypeID=0 and FLastModDate is null and FLastModUser is null
)) and FTypeID=0