TelevisionUUID , –<<Note, the columns here must be available to the output IsCheckedOut FROM dbo.Television tv WITH ( UPDLOCK, READPAST , ROWLOCK ) –<<Optional Hints, but helps with concurrency issues WHERE IsCheckedOut = 0 ORDER BY tv.TelevisionKey DESC )