[closed] Convert Query from SQL 2008 to SQL92 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 http://www.sqlinform.com/forum4/read.php?3,605,605#msg-605 Sun, 26 May 2013 07:31:37 +0200 Phorum 5.2.10 http://www.sqlinform.com/forum4/read.php?3,605,619#msg-619 Re: Convert Query from SQL 2008 to SQL92 http://www.sqlinform.com/forum4/read.php?3,605,619#msg-619 probably you need to ask this question in a dedicated SQL2008 + 92 forum.

Regards]]> guidomarcel Suggestions, Questions, Comments Fri, 02 Mar 2012 17:39:50 +0100 http://www.sqlinform.com/forum4/read.php?3,605,605#msg-605 [closed] Convert Query from SQL 2008 to SQL92 http://www.sqlinform.com/forum4/read.php?3,605,605#msg-605
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]]> Steve Anderson Suggestions, Questions, Comments Thu, 09 Feb 2012 16:28:42 +0100