>

>SELECT * from myTable WHERE ID = @ID WITH (READPAST)

>
>
>That's a good guess....but a READPAST essentially ignores a row where it can't get a shared lock.
>
>Again, in this situation, if a shared lock could not be obtained, we want the last good committed version.
>
>Give you a hint....think "camera"

Based on the hint I guess you're talking about snapshots.

CREATE DATABASE AdventureWorks_dbss1800 ON
( NAME = AdventureWorks_Data, FILENAME = 
'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks_data_1800.ss' )
AS SNAPSHOT OF AdventureWorks;

http://technet.microsoft.com/en-us/library/ms175876.aspx

I haven't played with them yet.