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...

CAST (CHD_MONTHLY_INT_RATE AS DECIMAL (12,6) ) /100000

The likely reason it took 78 seconds the first time is because it probably made TempDB larger... the default initial size of TempDB is woefully inadequate.  Our production box at...

Heh... thanks, James.  Yeah, I use it a lot, as well... there are a couple of methods that are a bit faster, but there's none simpler or easier to write. ...

Pretty sure thats not the way it works, Tomm.  If it's 14:00 in central and GMT is used to write the time, the time that will be written is 20:00...