A long long time ago, I seem to recall that it was possible to take your RAM and assign parts of it to a disk drive letter. Does anyone know...

Sorry can't seem to see navigate to the second page of this thread. But doing a reply I saw the last post on the second page. Thus are you getting...

What are you trying to do???

Your where clause has nothing whatsoever to do with what you are selecting.

'0'>'0' is ALWAYS false.

'0.00'>'0' is ALWAYS true.

Now what? Or rather, so what?

I don't know of the existence of this kind of service. I certainly cannot imagine a business model that would make something like this viable. Hardware is getting cheaper by...

OK, checking out http://www.netflixprize.com/

Will get back to you.

I seem to have seen this problem of movie ratings somehwere on this forum. Are sure you haven't discussed this elsewhere?

In any case, you have raised my curiosity. So spill the...

How about giving us a peek at those self-joins.

What kind of hardware are you running on right now?

Do you think just raw CPU power will solve your problems? Maybe it's the...

My only guess is that there is something on the connection that hasn't been closed or released or comitted or whatever. I would try this in a simple program that...

Is there an OLE DB provider for Excel? What does it look like?

Ever done an update with that or an insert into ... select ... from?

I guess OPENROWSET is just for querying. This is the first time I tried it. I couldn't...

Regarding point 3, the scripting runtime's File object does not have anything for getting at a JPEG's height and width. You'll have to use .NET.

But because I needed this as...

Amazing indeed. My select statement was dirt simple:

select distinct colname from tablename

When I removed 'distinct' the problem went away.

I then tried

select colname from tablename group by colname

the problem pops right...

I am currently struggling with a problem that has to do with the use of adOpenStatic vs adOpenForwardOnly under ODBC. Not getting your error message though. Instead when I try to read...

Why are our windows getting so wide? Is it something you did or is it something I did^

Can you give some insight into how you run a query without creating a linked server?

Thanks.