Is there any alternative function for Rank() or Row_Number() in sql server 2000?
-
I am using Rank() function in my VIEW. it working in sql2005 but not in sql2000. Is there any alternative function for Rank() or Row_Number() in sql server 2000?
-
I am using Rank() function in my VIEW. it working in sql2005 but not in sql2000. Is there any alternative function for Rank() or Row_Number() in sql server 2000?
No You can simulate it using a cursor and identity field
Never underestimate the power of human stupidity RAH
-
No You can simulate it using a cursor and identity field
Never underestimate the power of human stupidity RAH
Could you give a sample example for the same?
-
Could you give a sample example for the same?
Sorry mate you are going to have to do the work yourself, I am willing point the way not do the work. Besides I use 2005 why would i code for 2000.
Never underestimate the power of human stupidity RAH
-
Could you give a sample example for the same?
hey try this Select IDENTITY(int,1,1) AS [Row Number], FieldName INTO #Temp from EMPtable order by FieldName DESC SELECT * FROM #Temp WHERE [Row Number] = 10 hope this will help you.
Reasons are not Important but Results are Important. Swati