3 works on record
Inside Microsoft® SQL Server® 2008
Inside Microsoft SQL Server 2008 T-SQL Querying
Inside Microsoft SQL server 2005