To be quite honest, if another DBA/programmer brought the second statement to me, I'd ask him what he thought he was doing... The logic to think through that query is...

Marie, in this case, I think the derived table just makes it more obvious what the query is doing than the "WHERE...IN" version. SQL should only have to actualize...

I'm not sure about doing it in the connection dialog in QA, but you can always use SQL's Client Network Utility, found in the SQL program group, to configure an...

I think debugging technique is one of the most interesting topcis in programming. As such, this is a great question, IMHO, for an interview. Honestly, the content of...

You might do some research on the "NT Fibers" server option to get more information on how SQL handles concurrent execution.  I think that by default, it spawns a thread...

They way I've learned most languages is by needing to do something in the language that I don't know how to do yet. Then I'll hit up some web...

Jonathan appears to be right, you could rewrite this as an update.

Forgive me if I am wrong, but it looks like you already know how to program in another language...

The first step will be to export all of the images. You will probably have to write a custom application to handle this, but I suspect you already have...

I don't know that I would ever use a global table to look up so many attributes for a wide array of objects, but I have used a similar system...

That's pretty much what I was talking about... I was forgetting, however, that you can get around the message/status table being locked inside long-running transactions by using:

SELECT * from message...

I think that once you know how a language works and have a good understanding of it, then there's absolutely no reason in the world you should be typing everything...

Me too, actually. The first change I would make the the script I posted would be to make it take a parameter for the alias I wanted to use.

Incidentally,...

I use a method similar to the one scripted on the page Frank linked, except I don't use permanent temp tables, instead favoring a single message table that contains a...

To ease coding it:

select '[' + object_name(id) + '].[' + name + '] ,'

from syscolumns

where id = object_id('tablename')

order by colid

Copy and paste the result, remove the columns you don't want....

My personal preference for outputting data to Excel is via a DTS package. If I need to pass a variable to it, I create a global variable and pass...