WITH CTE AS (

SELECT TOP 10000

ROW_NUMBER() OVER (ORDER BY a.object_id) - 1 AS RowNbr

FROM

sys.all_columns a

CROSS JOIN

sys.all_columns b)

SELECT

RowNbr

FROM

CTE

WHERE

RowNbr <= DATEDIFF(HOUR, '2014-08-07 10:00', '2014-08-07 18:00')

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]