以下代码
DELETE dbo.Revenue;
INSERT INTO dbo.Revenue
SELECT *
FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY Transaction_NUmber ORDER BY Transaction_NUmber) AS rownum
FROM DBO.VMRevenue) AS TEMPRevenue
WHERE rownum = 1;
SELECT * FROM dbo.Revenue
直接在查询分析器可以正常执行，有900多条记录插入了表中；但是如果使用系统的Export Data功能，将输出导出到Excel中，这段代码放在执行脚本里，则输出信息为0行；
为什么？谢谢！
系统有一个Warning： Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (SQL Server Import and Export Wizard)
