Seems as though 7/7 has got everyone thinking the what if's should you or a loved one be caught in an emergency situation.

Heres a useful one found at the link below - just put a contact in your mobile called ICE (In Case Of Emergency) with the mobile/home numbers of the person you want the emergency services to call should something happen and your unable to make that call yourself.

Pass it on, the more of us that use it the more the emergency services will know to look for it.

http://www.eastanglianambulance.com/content/news/newsdetail.asp?newsID=646104183

This article describes how to delete a single row, when it is found that row is duplicated

Set Rowcount 1
Delete From
Table
Where
ID = 999 (Or any field name/value combination that identifies the duplicate row)
Set Rowcount 0

This article describes how to identify duplicate records in a SQL table.

Use the Group By / Having combination in a Select statement

Select
ID
From
Table
Group By
ID
Having
Count(ID) > 1