I have inherited an application that has a DTS package. One of the functions in this package is to remove duplicates from a table. The query looks like this:
SELECT DISTINCT(nurseID), fname, lname, careerLadder, bcon, ssn, domainAccount INTO #nursesDistinct FROM nurses; DELETE FROM nurses; INSERT nurses SELECT * FROM #nursesDistinct; DROP TABLE #nursesDistinct; Problem is that this does not work. When I run this I receive an error message: Error Description: Insert Error: Column name or number of specified values does not match table definition. What does this mean? Thanks, Bruce ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
