0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for alcoholic beverage aficionados and those interested in beer, wine, or spirits

DECLARE @offset int = ##offset##
DECLARE @step int = 10000

SELECT
    Id, PostId, UserId, CONVERT(float, CreationDate)
FROM
    Comments
WHERE
Comments.Id BETWEEN (@offset*@step) AND ((@offset+1)*@step-1)

fork query

edited nov 30 12

created nov 30 12 jon.doe10048