ACtually - no. RANK just needs to be run over the top N and in everything from "camry" upwards. Everything else is worthless.

with that in mind:

declare @g datetime;

--create...

I did catch that, and I'm not denying in any way that your metric is required to get to the top 10, 15, 20, etc... choices they might want. ...

You're missing the point I'm trying to make: the two are related. By not giving it something to work with that it "likes" (i.e. appropriate indexing, etc...), and by...

Again - look at some of the comments Steve put in. You REALLY don't want to assume you will be updating just one row at a time. You...

I'll pass...:hehe:

Too messy for me, but thank you for asking.

Just about any SELECT statement would fall apart with that syntax, since you're trying (incorrectly) to use what is called "dynamic SQL".

Here's an example of what you're looking to do:

declare...

Totally agree with the above suggestions.

If you happen to be building this 5MB file of inline commands - might be worth just making it into an XML data file, or...

First - have you looked at using the WITH TIES syntax?

Second - the fact that you're using single-column indexes to do this points to why everything is slow.

The view part...

Just so we can all get into the right habits - use the three-part names like Matt Stockham pointed to, but do so only in the FROM clause, assigning an...

I usually bulk insert into a "real" table as you call them. Usually a "copy" of the real table (empty table with same DDL structure as the real one),...

What index are you using? Are you sure the compiler even used it?

All of the items to posted had the Top(N) syntax in it...

Without the RIGHT index (the one...

Thanks for the feedback - you're welcome:)

More often than not, this is caused by Access not being able to tell what constitutes the Primary Key of the new "linked tables".

Try opening the linked table...

Andy Warren (2/4/2008)

---

I think most businesses 'get' that IT isn't just a loss center even if it looks that way on the P&L. Those that don't implement stuff like chargebacks...

rolli (2/2/2008)

---

David,

I tried this query

UPDATE detail_data1

SET time = DATEADD(ss,T.ID-DT.FirstID,GETDATE())

FROM detail_data1 AS YT

INNER JOIN detail_data1 AS T ON YT

INNER JOIN (

SELECT person_id, date, time, item, visit_id

FROM ...