Viewing 15 posts - 616 through 630 (of 672 total)
Unicenter i$ good to Monitor Harware and $erver health.
$potlight on SQL Server by QUEST is good, but I liked the version before they made it look more like a stoplight...
November 5, 2010 at 7:50 am
Toreador (11/5/2010)
tilew-948340 (11/4/2010)
My engish beeing what it is, I did also not get the differance between the first two
Don't worry about it, I've lived in England for all 47...
November 5, 2010 at 7:24 am
SQLNeophyte (11/4/2010)
Hi Sandroid,Currently the output is 2 differnt case Activities with the Max date, the o/p should be Max date with the Case Activity on that date.
Then you will have...
November 4, 2010 at 2:31 pm
CELKO (11/4/2010)
November 4, 2010 at 1:32 pm
A Max and Group by with the Date Filter on the Join should do the trick.
select p.first.name,p.last.name,c.case_status,c.program.type,c.counselor,MAX(ca.activity_datetime) as activity_datetime,ca.activity
from participants p
inner join cases c on p.participant_id = c.participant_id
inner...
November 4, 2010 at 1:05 pm
mislamuddin (11/3/2010)
Hi:If select distinct specified order by item must appear in the select list and there will be error message as follows:
Msg 145, Line 15 St 1
I did not get...
November 4, 2010 at 8:02 am
Michael Poppers (11/3/2010)
and perhaps that was his intention :-).
Good point. It could have been his attention from the start.
It would not be the first time the QOTD was differant...
November 3, 2010 at 10:20 am
Nice question.
I learned something, there were no errors or typos with the answer, and the reference data supported the documentation.
The only negative comment I have is that this...
November 3, 2010 at 7:05 am
If you have never run a backup of the Database (I bet you have not) you will need to do this first.
After that you can either do a real Tran...
November 2, 2010 at 7:53 am
Hugo Kornelis (10/28/2010)
I wrote that NULL does not represent unknown.
I understand that is what you wrote.
I thought maybe you would look at the referenced article before responding.
Let me...
October 28, 2010 at 3:23 pm
Great question Sunil.
Good example of how NULLS are counted in a column of data.
I also give this question 5 stars for having no typos or confusion in the...
October 28, 2010 at 1:04 pm
Hugo Kornelis (10/28/2010)
Good question, but a small (yet significan) mistake in the explanation.NULL does not represent the value 'UNKNOWN'.
Hugo, perhaps you could ask M$ to update the books online to...
October 28, 2010 at 12:58 pm
da-zero (10/28/2010)
Well I did 🙂 I just ignored because it was an obvious typo (and the answers didn't have any error messages)
As did I, but it explains why some people...
October 28, 2010 at 7:02 am
Hugo Kornelis (10/27/2010)
SanDroid (10/27/2010)
Hugo Kornelis (10/27/2010)
And if you ever install SQL Server on a German OS, acccepting all defaults, you'll find that the Server language also defaults to German..
October 27, 2010 at 3:53 pm
GPO (10/27/2010)
spelling and gramer
😛
Glad that did not go unoticed. :hehe:
October 27, 2010 at 1:19 pm
Viewing 15 posts - 616 through 630 (of 672 total)