Thanks for the reply. I was wondering why I couldn't find any texts out there specifically for the upgrade test. Probably people trying to make money on the...

It's funny. I never got notified of a reply to this thread or my other thread...

I'd love to hear from anyone who has taken the exam as to its...

Sorry, but no. The PIVOT operator requires some sort of aggregation. Whether you're averaging or summing or whatever.

Someone did post a CASE statement SELECT which is...

The easiest way is to join the table to itself.

Delete from MyTable

from MyTable t1

left outer join (Select Distinct Name, Max(Eff_Date)

...

The way we do it is that we have a Dev instance on one server in the cluster and then our Test / QC instances on the other server in...

Well, I passed.  WHOO HOO!  I think that means I get to add more letters to my .sig. @=)

Anyway, I do advise anyone studying for this test to be 100%...

Going over the practice test again.  And here's an annoying question "Which of the following are valid configuration options?"

This is why this book frustrates me.  It doesn't explain WHAT you're trying...

Locking down the SSIS packages and such means, take everything away from him once it's developed.  Do not allow him access to Integration Services on the Production server, make sure...

If I read the first post correctly, it said that log files go missing during the middle of the night.

There has to be a way of copying those logs off...

I have to agree with Andrew's comment on using the IF...ELSE statement. 

You repeat your search for @Value IS NULL twice, first right after the WHERE clause and secondly as...

I can only think of the obvious answer.  Ask them.

Of course, if you don't work for the DOD, then you probably won't get an answer.  If you do work...

Actually, it's a char(2) and the value will never be less (unless it's NULL and I've got that check taken care of).

But the warning is well heeded.  There are days...

WHOOHOO!

I had to sacrifice my % sign because the table I was updating had integers in the columns instead of characters, but I finally made my percentages Pivot table dynamic. ...

Unfortunately, I can't see your pictures.  My browser is just showing two little white boxes with red X's in them.

Can you paste in text?

Darnit...

I was hoping that wasn't the answer.  I ran into that problem this morning with a T-SQL send mail proc that doesn't use DBMail.  So I was hoping switching my...