Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sam2mis
Starting Member
1 Post |
 Posted - 2008-03-28 : 01:00:38
|
| Hi guys I am new to SQL Pls help me on this...In sql server 2005 we have ROW_NUMBER() as inbuilt function...But i am using sql server 2000... instead of ROW_NUMBER () what is the functionality in SQL SERVER 2000. can anyone help me out in this pls...Thnaks in advance!!!!Thanks and Regards,Samuel P |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2008-03-28 : 01:07:17
|
| There is no row number in SQL Server 2000. Please explain your requirement and may be someone can suggest an alternative solution. |
 |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-03-28 : 01:46:48
|
| see if this link helps you. You will have to use correlated query to get the row number.http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=144651&SiteID=1 |
|
|
|
|
|
|
Doubt is SQL