Viewing 3 posts - 1 through 3 (of 3 total)
Hi all,
I agree this is a problem related to Rank in SQL server 2005. But this can still be achieved with SQL Server 2000 also in a single query given...
July 10, 2008 at 1:28 am
#840662
What is the value of file growth for data file and Transaction log of the database? If the value is more (by MB or by %) , it may cause...
June 4, 2008 at 3:25 am
#824054
The answer is partly correct. The query works pretty well and outputs the resultset correctly in SQL Server 2000. We need to prefix table name/ alias in SQL Server 2005....
April 28, 2008 at 1:16 am
#807613