help writing sproc - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

help writing sproc

Author

Topic

mike123
Master Smack Fu Yak Hacker

1462 Posts

Posted - 2004-01-19 : 03:04:04

I have a table, that was built without constraints. I have many duplicate records.

What is the best way to delete duplicate records?

The table (tblInterests) is built as such (with some sample data)

userID, interestID

500, 1
500, 2
500, 2
500, 2
500, 5

Thanks again for any help

mike123

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-01-19 : 04:52:38

Hey Mike

This one is in the FAQ http://www.sqlteam.com/item.asp?ItemID=3331