Forum Replies Created
Viewing 15 posts - 61 through 75 (of 85 total)
-
RE: Question of the Day for 28 Jul 2004
Well, I cut and pasted the queries directly from the web page and it worked exactly as I expected. Query 1 returned 1,2 and Query 2 returned 3...and I got...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 18 Aug 2004
The question was:
"Can you use an ORDER BY clause in this view definition?"
and the answer is NO!
if this were the view definition:
create view NorthViewasselect TOP 10 accountID,...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 09 Sep 2004
BS!
It is obvious from the wording of this question, the intent was to confuse, not teach. The fact that 49.7% of the respondents answered 2GB should be proof of that.
And...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 20 Sep 2004
Why do you guys even bother with discussions over this.
1) author can't type
2) author gives WRONG answer
isn't worth my time...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 15 Sep 2006
Just be thankful this author's finger was on the keyboard and not "THE BUTTON"!
I got it WRONG for the same reason
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 17 Nov 2004
What does it matter in the end if we don't send the French their email?
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 14 Dec 2004
Please explain why this answer is correct when I get the following error when I run the code as provided:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 18 Jan 2005
Actually, MaxActiveReqForOneUserin parameter does not exist. So there is no correct answer as listed...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 03 Mar 2005
refer to the following article which explicitly states (in underlines) that "a recursive query is made up of 2 queries joined by a UNION ALL".
end of story!
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 17 Mar 2005
Here! Here! I won't whine, but I'll certainly gripe! I'm continually amazed that so many alleged analytical people can come up with so many ambiguous questions.
and I GUESSED wrong
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 24 May 2005
Looks like we have conflicting information:
http://support.microsoft.com/?kbid=897284
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 12 Aug 2005
Trick question. BOL says it captures "T-SQL"...
Your multiple choice question provides an answer which which includes the key word "T-SQL" and the correct answer which does not...implying that it is...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 23 Aug 2005
Another wonderfully crappy question...but if you stare at the screen and squint really hard, you can recover any database using that script!
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 24 Aug 2005
If you stare at the screen and squint really hard, you can use the mirror for reporting.
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
-
RE: Question of the Day for 09 Sep 2005
A result set can take many forms...including a single value, in which case, an Object data type would be overkill. The question does not provide enough information to give a...
Take care,
Bert
"Speculations? I know nothing about speculations. I'm resting on certainties. I know that my Redeemer lives, and because He lives, I shall live also." - Michael Faraday
Viewing 15 posts - 61 through 75 (of 85 total)