SELECT TOP 5 * 
FROM dbo.Objects_tbl with (nolock) 
where 
 Objects_tbl.ObjectClass='DS'
 AND Objects_tbl.ProcStateColRf IN ('N')
 AND Objects_tbl.ObjectFromSiteID IN ('HIL_QS')
 And Objects_tbl.ObjectOwningSiteID='HIL_QS'
 And Objects_tbl.ObjectUgMaster_Type = 'SP'
 AND Objects_tbl.ObjectType IN ('UGMASTER')
 AND Objects_tbl.ObjectFs_Vol IN ('vol1','vol2')
 ORDER BY
 Objects_tbl.ObjectCreateDate DESC