Thursday, November 11, 2010

Cross-Platform CSS Fonts

Here's an excellent resource for choosing font families that will work across all major platforms http://my.opera.com/area42/blog/css-font-matching-windows-mac-and-linux.

Deleting Duplicate Records

Similar to this post http://damianfiles.blogspot.com/2009/04/finding-duplicate-records.html, the below SQL will delete any records that have 'dupField' in common. It will keep the record that has the lowest 'uniqueField' value.

delete T1
from MyTable T1, MyTable T2
where T1.dupField = T2.dupField
and T1.uniqueField > T2.uniqueField

Found here http://www.cryer.co.uk/brian/sql/sql_delete_duplicates.htm.