Definitely need the table definitions to solve this one. With those, will only take a minute or two.

I may be missing something, but I don't see where the first query has a loop for the databases in it.

Shouldn't it have "while @@fetch_status = 0 ... fetch next...

My first instinct would be to normalize it.

Create a table for types and a table for colors, then have Date, Name, TypeID, ColorID and Qty in the main table. ...

Triggers run once per command, not once per row. I think, but could be mistaken, that they run once per row in Oracle.

It's very important in MS SQL to...

Two different queries producing the same results with the same execution plan can very definitely take different amounts of CPU time.

Heck, the same query run two or more times can...

I've used UDFs in cases where the select logic was so insanely complex that a single query just couldn't do it (which leaves out views) and it needed to be...

Check out: http://www.apexsql.com/sql_tools_edit.asp

It might already have the kind of feature you're looking for. If not, the owner of ApexSQL is pretty easygoing when it comes to taking requests for...

I'm sure it's possible, but I've never seen anything that would do it.

I can't speak for the CLR implementation Matt is suggesting, but the cursor would look something like:

declare C1 cursor local fast_forward for

select Wrong, Right

from Metadata_Acronyms

open c1

declare @sql nvarchar(1000), @Wrong nvarchar(100),...

Another thing to watch out for (I burned myself this one) is Mac. For example, you want to end up with "Sean MacDonald", but not with "Joe MacY", so...

I believe the answers are Yes and Yes. Start here:

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

That has what Microsoft has to say about the subject and how to go about doing it. (It's more...

Restoring an SQL 2000 database on SQL 2005 is usually just a simple matter of restoring from the backup. I just did five of those last Friday (getting ready...

Since you're using the replace command (and I can't think of another way to do what you need), I think your best bet is a cursor to step through the...

To my knowledge, it just has to be same on all nodes, but doesn't necessarily have to be c:.

Ah. Can't help on that one. I haven't had time to try out VS 2008 yet.