Steve Jones - Editor (7/13/2009)

---

It's interesting to see the responses, and thanks for them.

There's a huge gap between "don't use the cloud" and "put all our systems in the cloud"....

On the idea of multiple queries to handle the OR problems, you don't actually have to modify the front end. Have the main proc call sub-procs based on the...

Mel Harbour (7/13/2009)

---

And here's the plans for the temporary table with the index added.

Out of interest, Gail, when you say that it looks better already, what part are you referring...

As far as a revamped solution goes, here's what I've come up with so far.

create table dbo.Users (

UserID int primary key,

DisplayName varchar(100));

go

insert into dbo.Users (UserID)

select Number

from dbo.Numbers

where Number <= 1000;

go

CREATE...

The CSV doesn't have column names, but it looks like they should be ID, UserID, Date, Points, Category. Is that correct?

Not sure I'm clear on the Date column.

If I get 1 point today, and 1 point tomorrow, and have no previous points, would I have an entry for today that...

It looks like the whole thing hinges on the UserPoints table.

Can you provide the DML for creating a copy of that table, and a sample insert statement? If you...

Just like any other machine built by man, Google has flaws. "The Cloud" has flaws and always will. There are no perfect machines.

The thing I don't like about...

Also take a look at the Except function in SQL 2005. That one can make finding table differences quite easy.

Yes, I've definitely seen differences with the math in Where vs Join. But the above two don't appear to have that.

Would be easy enough to create a sparkly glow... there's got to be enough tritium in the world for that! (Sorry, couldn't resist.)

Have you just tried selecting from dbo.sysusers?

What's the view for?

(Depending on that, I may have different suggestions for different purposes.)

I don't think where you get them will matter.

HR depts are just looking to see if you have some alphabet soup. Tech screeners are just looking to see if...

Can you post the execution plans?