Oh, DUH! I thought I had to list the attributes separately with an open & close....

Thanks. I'll try again. @=)

One of those situations where being able to speedread is helpful...

How much time do they generally give you on a case study?

WHOOHOO! Text file worked. At least, it opens for me and displays my code correctly. Let me know if you can't see it.

Well, gosh darnit! The webpage probably parsed it funny... And I forgot to preview it.. Let me try again.

Hmmm, double-quotes won't work. I'm going to try to...

Well that makes me feel a lot better. I was worried that the Case Studies were going to be worded in a kind of "Write 500 words describing your...

At the very least, we should be automatically subscribed to the threads we start. @=)

But since you said you're looking at it, I'll behave myself and won't bang my soupcan...

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...