For earlier versions of sql that don't have row_number or cte's you can use the following :-

SET STATISTICS TIME ON

DECLARE @DUMMYVAR INT

SELECT @DUMMYVAR = seq

from

(select...