Liliya,

That actually might be one of those little things that differs from auditor to auditor.

None of the local department ITS support groups in my workplace have actually been...

To be honest, we don't have an Administrative DBA. We just have a small team of 3 DBAs who do it all, Operational, Development and Administration. Yes, a...

Megan,

In the text file, I don't see anywhere where @PO is being declared or set. that might be part of your problem. Not sure if that's the sum...

Actually, I found an easier way. Apparently Access 2003 DOES allow upsizing the table structures only.

Last time I upsized a DB, it was Access 97. Talk about behind...

Really? Because when I took the 70-431 exam, the sims were timed differently from the rest of the exam.

There are new datatypes in 2k5, and text / ntext / image datatypes are due to be depreciated in the next couple of versions, but I don't think they actually...

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