sandy (2/2/2009)
Hi Vladan,When i run this code is sql 2000 i get an error of
Server: Msg 195, Level 15, State 10, Line 27
'ROW_NUMBER' is not a recognized function name. but it runs perfectly in sql 2005 is there any way i can run it sql 2000
No there isn't. On SQL Server 2000 it has to be done differently. Please next time check where you are posting - this is forum for SQL Server 2005 - that's why I came up with this solution. Sorry, I'm just leaving and won't be around for 2 or 3 days now... hope you get some response from other people.