For a great discussion of your options, that can be done without iterating through each row, look at:

http://www.sqlteam.com/item.asp?ItemID=3856