Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: Manish Swami
  Where is Manish Swami?
 SRI GANGANAGAR
 India
 Manish Swami
 Tags
Subject: RE: SQL Server Error (Driver)
Thread ID: 394008 Message ID: 394013 # Views: 46 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: General VFP Topics
Date: Saturday, December 28, 2013 2:03:40 PM         
   


http://sqlserverplanet.com/sql-2000/simulate-row_number-in-sql-2000
lots of other refs if you google "row_number mssql 2000"

Btw, I'm wondering out loud here why you did not state that in your first post

.





> http://technet.microsoft.com/en-us/library/ms186734.aspx
>
> it works SQL Server 2005 but tried to run it on an SQL Server 2000 database and says:
>
> ROW_NUMBER it's an unknown function name or something like that.
>
> Any Alternate for SQL 2000
>
> > ... row_id,row_number()?? over ....
> >
> >
> >
> >
> > .
> >
> >
>
>
>
> Regards
>
> MANISH SWAMI
> www.gaurisoftwares.com
> My Blog : - www.gaurisoftwares.blogspot.com
> code.google.com/p/gaurisoftwares

ENTIRE THREAD

SQL Server Error (Driver) Posted by Manish Swami @ 12/28/2013 1:23:22 PM
RE: SQL Server Error (Driver) Posted by David Mustakim @ 12/28/2013 1:29:13 PM
RE: SQL Server Error (Driver) Posted by Manish Swami @ 12/28/2013 1:42:33 PM
RE: SQL Server Error (Driver) Posted by David Mustakim @ 12/28/2013 2:03:40 PM
RE: SQL Server Error (Driver) Posted by Manish Swami @ 12/28/2013 4:11:21 PM
RE: SQL Server Error (Driver) Posted by Pete Sass @ 12/28/2013 6:17:20 PM
RE: SQL Server Error (Driver) Posted by Manish Swami @ 1/1/2014 3:29:24 PM