DECLARE @Start datetime,
@End datetime
SELECT @Start = 11,
@End = 20
SELECT objName, CrDate
FROM (SELECT ROW_NUMBER() OVER (ORDER BY name)
AS Row, convert(varchar(30), name) as objName, crDate FROM sysobjects)
AS DatabaseObjects
WHERE Row >= @Start AND Row <= @End