How to delete duplicate records from a table with one single SQL query.
I do not want to use temp or another table.
Thanks
Kiran



---------------------------------
Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs
MS Sql Server LazyDBA home page