Ouch, Michael!

Jambu's first post in this thread got me to thinking more about my heros growing up.  My grandfather, on my Dad's side, was a good man, but he was also...

I, too, had Roger Stauback as a hero when I was a kid.  Funny, you don't hear much of him now a days, but he was great.

But another for me...

Hello Lisa,

I'm am home now, thus the different "handle" (at work I use "Rod at work"; at home it is "Doctor Who").

I'm sorry, I did not mean to offend.  I...

That is a good idea, RGR'us (about trying to make that one programmer into a DBA).  Set operations might really be more to his liking.

Thanks!

RGR'us, for us the issue is that one of our developers has a very hard time with OOP concepts.  He just doesn't seem able to wrap his mind around them. ...

That 64% who still code in VB6 doesn't surprise me.  I've been at the same company for 10 years, where we wrote an OK VB6 app 10 years ago, and...

Is the Service Manager that was a part of SQL Server 2000 and runs in the system tray, still a part of SQL Server 2005?

Yes, Steve, I do mean the user logs into the console on the workstation.  I'm running Windows XP Professional SP2.  I'm looking under All Users's Startup folder and I...

Chris,

When you say that you did a fresh install, do you mean that you had to uninstall SQL 2000 first?  And then do a restore of your databases, in order...

Thank you, Neal, PW, Ron, Sergiy and Kenneth for your help. 

OK, PW, I now see what you are saying.  I've changed the SELECT to look like this:

Select p.DisplayName,

count(r.ClientNumber) as 'Count'

from Providers p

left join Referral r

on p.ProviderNumber = r.ProviderNumber and...

noeld, I tried doing what I think you suggested, and got the following:

Select p.DisplayName, count(r.ClientNumber) as 'Count'

from Providers p

left join Referral r

on p.ProviderNumber = r.ProviderNumber and p.Facility = r.Facility  and p.Condition1 =...

I've got to ask a follow up question.  I am not certain when I should execute the

DBCC TRACEON(3604)

DBCC TRACEON(1294)

commands.  For example, I've got a situation in which a deadlock...

That was it, Raj, thanks.

quote:

---

Could be due to output size limitation set in the query analyzer.

Note that when you say for...