No,...

Here's an easy way to create and populate a Dates table:

Create table Dates(D datetime primary key clustered)

GO

Declare @FirstDate datetime

Declare @LastDate datetime

Declare @Days int

Set @FirstDate = Cast('1970-01-01' as datetime)--<< change these...

My guess would be that either your stats need to be updated/regenerated or you've got a parameter sniffing issue with the proc.

Uh, steve, this "ALL" query is the same as the "ANY" query last week, but it now reports a different answer. NOTE that the word "ALL" does not appear...

I agree with you and Stephen Forte, Steve. We should embrace the impedance mismatch. The realtional interface is not a problem that needs to be solved. Lazy...

Yeah, actually I do know that... 🙁

OK, I sent you the draft. Heh, I didn't see your reply before I sent, hopefully the mess o' text I sent will be alright.

Heh. Now you tell me!?!

Seriously, though, I thought...

Thanks for the feedback, Jeff.

Yes, that's what the Browser service does: It enables browsing to the SQLServer Instances on that server.

Only to you. For the rest of us it is merely confusing because you haven't really told us anything and you haven't answered any of...

Note that "TOP 5" is not really meaningful in this context because you have not defined an order.

Actually, no. This is what you are trying to...

Doctor Who 2 (6/28/2008)

---

Jeffrey Williams (6/27/2008)

---

Since this is the default instance, you can type in one of the following to connect:

.

(local)

localhost

computername

Another option is to browse for more in the drop-down....

Yes, Mark has it. You should be able to convert all of them like that.