http://www.acronymfinder.com/af-query.asp?String=exact&Acronym=IIRC

I know. Waiting for a new laptop to arrive and being installed. So, only a matter of time till I ask.  

Amazing, to hear that from you...

Create the table and then run an ALTER TABLE script on them. Maybe with sp_Msforeachtable or so.

...then let us finally participate on thy wisdom!

Blame it on the language barrier. I meant that you cannot specify an ORDER BY along with the UPDATE. Sorting might be a better word.

Don't you think you're mixing presentational issues in here very heavily?

Use INSERT INTO ... SELECT to move the data and thereafter DELETE. Both syntax are explained in BOL.

String or Binary data would be Truncated.

The statement has been terminated.

Have a look at CAST and CONVERT in BOL. This error typically arises when you try, for example, to push...

Chris already mentioned all there is to say. You should suggest, more or less gently, that those developers take some course in database design. Maybe you can get your hands...

RobF (not an MVP... although I keep thinking that Microsoft must be missing out )

Don't worry about that. After all, it's just another...

But that's just because I prefer correctness to performance.

Now, good to hear that.

I almost thought that everybody's more crazy about performance and speed and tweak that and tune this as integrity and...

Have you already looked in the SQL Server 2005 Books Online ?

There are quite a few useful threads here on the forum. So, if you have time you might want to browse them. See if this also helps: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp

But that's why he put the index on the table, so that it would order it for him without changing the 'order by', right?

Rob, you should know better. While...