Can this be done in SQL92?

SELECT A.* from SharePointProgress.dbo.tblMscShpDt A
INNER JOIN
(SELECT ROW_NUMBER() OVER(ORDER BY intid) AS 'RN', *
FROM SharePointProgress.dbo.tblMscShpDt) B ON A.intid= B.intid
AND B.RN between 20 and 30



Edited 1 time(s). Last edit at 03/02/2012 05:40PM by guidomarcel.

Hi Steve,
probably you need to ask this question in a dedicated SQL2008 + 92 forum.

Regards



Edited 1 time(s). Last edit at 03/02/2012 05:40PM by guidomarcel.