Using an SQL timestamp value in an SQL Execute query

I am attempting to select data from an SQL Server database and using a timestamp in the where clause and having some challenges. I am taking a 2-step process: Select from a DB table the most re...