Try this.

Select itemno, Qty2002,Qty2003,Sales2002,Sales2003, () Do some math) AS sales$difference, (do some math) AS sale$%var

FROM (SELECT TOP 100 PERCENT itemno, SUM(CASE WHEN YEAR(SHIPDATE)=2002 THEN qty ELSE 0 END) AS Qty2002,...

I agree, badly worded QOD yet again. I'm thinking I might as well give up on taking the questions and just look at the message boards to extend my knowledge.

I stand corrected =)

I bow down, my answer was wrong.

Correct, 5j% is not 5% therefore the answer presented as correct is incorrect. Try this updated code.

Create Table #test1(col1 varchar(200))

insert into #test1(col1) values('some 5% interest')

insert into #test1(col1) values('some 5j% interest')

SELECT...

I'm a little put off by the answers presented as there are two answers that are correct, not just one.

In addition to the answer presented as correct, you can also...

Please keep in mind that a human being wrote these questions and answers, and while we may not like the context, we should avoid using words like moronic as they...

What is the first thing you should troubleshoot in this default installation?

I have to say once again, the answers (not all of them, but 3 of them) I don't...

You could do error checking within a stored procedure that is called from an application error. The only time I would see this as being a valid way to check...

SQLBill, The answer is still valid. It asked what SQL you could run. You could run HAS_DBACCESS to determine if you had access to the database, then handle the result...

What a can of worms I opened =)

I still have to disagree that the question was phrased incorrectly. Again, the question was What is the best explaination of why you...

I was ranting about the question which was: What is the best explaination of why you would use the HAVING clause in T-SQL?  and has nothing to do with the...

Well, as the Question states, you need to setup a global variable that holds the name of the database you'd like to have transfered and backed up.

Then, use the Dynamic...

Do you mean a generic package or a SQL Job? If you just need to backup the databases, you can setup a SQL job with a step for each backup that is...

Setup a connection object from the sql server and one text file destination connection for each text file you want to export to. You can then hightlight the server connection,...

Nice article. As mentioned already, it was a tad short but a good introduction to WMI.