22,210
社区成员
发帖
与我相关
我的任务
分享
--楼主没给数据,仅供参考吧:
INSERT INTO tablename
(
UsrID,
UsrNBR,
CustomerID,
AcctID,
EIGNO
)
SELECT
B.UsrID,
B.UsrNBR,
B.CustomerID,
B.AcctID,
B.EIGNO
FROM (SELECT DISTINCT CustomerID FROM tablename) a
CROSS APPLY
(
SELECT TOP(1) UsrID=CustomerID,UsrNBR,CustomerID,AcctID,EIGNO
FROM tablename m
WHERE m.CustomerID = a.CustomerID
AND NOT EXISTS
(
SELECT 1
FROM tablename n
WHERE n.UsrID = m.CustomerID
AND n.UsrNBR = m.UsrNBR
AND n.EIGNO = m.EIGNO
)
) b