Viewing 15 posts - 9,391 through 9,405 (of 9,725 total)
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...
September 28, 2007 at 7:33 am
Really? Because when I took the 70-431 exam, the sims were timed differently from the rest of the exam.
September 28, 2007 at 7:25 am
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...
September 28, 2007 at 7:24 am
Oh, DUH! I thought I had to list the attributes separately with an open & close....
Thanks. I'll try again. @=)
September 28, 2007 at 6:09 am
One of those situations where being able to speedread is helpful...
How much time do they generally give you on a case study?
September 28, 2007 at 5:10 am
WHOOHOO! Text file worked. At least, it opens for me and displays my code correctly. Let me know if you can't see it.
September 28, 2007 at 5:04 am
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...
September 28, 2007 at 5:03 am
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...
September 27, 2007 at 10:02 am
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...
September 27, 2007 at 5:14 am
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...
September 27, 2007 at 5:09 am
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...
September 27, 2007 at 5:07 am
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...
September 26, 2007 at 9:17 am
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)
...
September 26, 2007 at 9:06 am
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...
September 24, 2007 at 9:01 am
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%...
September 24, 2007 at 4:18 am
Viewing 15 posts - 9,391 through 9,405 (of 9,725 total)