0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for administrators and users of the CiviCRM Constituent Relationship Management software

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