raghuldrag (9/11/2012)
hey friendi am executing dis qury on sql server 2000 only...its not server 2008
I guessed that much from the subject of your post.
Here is a link to the SQL Server 2000 forum.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.