Thank you for the high favor Mr. Polecat.

David is correct, though... take a peek at the link he provided for the "unstable" version

You are correct.... I don't make the same argument against Redgate because they ligitimately advertise instead of resorting to spamming a forum.  Your product is well founded... your advertising method...

Execute DBCC UPDATEUSAGE(0) for the current database and then take a look at the ROWS column of the sysindexes table.  If you join the ID column of sysindexes with the...

Arthur,

The only thing that you have to remember is that if anything comes between the statement that creates the row count and the insert, then you'll need to use James'...

Perfect... Couldn't have said it better... and have been through this with these folks more than once.  Almost nothing worse than folks that spam forums.

Even if you don't build views on the sorted view, consider this... what if you want the data from the view to be in a different order?  The view will...

Ummmm, why can't you just use a simple insert statement????

INSERT INTO #Log (MessageCount)

SELECT LTRIM(STR(@@ROWCOUNT))+'...

What?  No shameless product spam, James?

Here's a few more links from the Google search...

http://www.vesigo.com/SQLServer/DatabaseServerComparison.aspx

http://www.promoteware.com/Module/Article/ArticleView.aspx?id=23

http://builder.com.com/5100-6388-1054385.html

http://searchsqlserver.techtarget.com/originalContent/0,289142,sid87_gci1211452,00.html

Here's a couple of other things from a more recent article that compares MySQL 5 against SQL Server... these things are crucial, in my book, and favor SQL Server... a...

And, they would have to rewrite any existing code because the many of the advanced SQL Extensions in both are different... SQL is NOT SQL

IF OBJECT_ID('TempDB..#FileExist') IS NOT NULL

DROP TABLE #FileExist

Make sure the name of the table is correct.

Or... use a BCP Format file...

Alvaro... really, really bad idea to sort in a view... really bad...

Like everyone has stated... bad idea.  Should be done with reporting software or a GUI if you have one.  I, too, question the table design for having what appears to...