Posted by Driesen via SQLMonster.com on 10/12/05 11:40

Hi Erland

Thanks for the help. I did drop the ORDER BY. The only reason this takes so
long to run is becasue our DataBase sits over 500 miles away. We to get
through a whole lot of banking environment security to access our DB.

Driesen


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200510/1

• Next in forum: Re: Backup for one new DB failing in regular maintenance job Error 3201
• Prev in forum: Re: Any way to optimise this query?
• Thread view: Re: Any way to optimise this query?

[Reply to this message]