Viewing 15 posts - 9,391 through 9,405 (of 9,720 total)
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
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...
September 21, 2007 at 7:45 am
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...
September 20, 2007 at 12:24 pm
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...
September 20, 2007 at 8:40 am
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...
September 20, 2007 at 8:27 am
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...
September 20, 2007 at 8:21 am
Viewing 15 posts - 9,391 through 9,405 (of 9,720 total)