Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 3 of 3
Search took 0.00 seconds.
Search: Posts Made By: joeman
Forum: SQL Server 2000 October 19th, 2007, 06:51 AM
Replies: 15
Views: 3,790
Posted By joeman
Of course i dont load it directly into production...

Of course i dont load it directly into production tables!! im crazy, but not that crazy!! :D

I have a totally separate staging database on a second machine so that i can mess about with the data...
Forum: SQL Server 2000 October 17th, 2007, 05:12 PM
Replies: 15
Views: 3,790
Posted By joeman
LOL, true, but back to the real world it can...

LOL, true, but back to the real world it can still happen...
i had it happen tonight when loading in data from an external CSV data source.
Although the data had unique rows in the CSV file, by...
Forum: SQL Server 2000 October 17th, 2007, 02:45 PM
Replies: 15
Views: 3,790
Posted By joeman
in SQL 2005 you can use the new row_number()...

in SQL 2005 you can use the new row_number() function.
this will allow you to identify each row and delete duplicates.
:)

row_number...
Showing results 1 to 3 of 3

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.