Since we talking wish lists - perhaps use that to somehow bring out those threads that used to get the old Moderator's "this hasn't been answered - please post anything...

Spaces sometimes get "eaten" when you cut and paste off of this board. Just mast sure to put a space in front of the word WHERE in the SQL...

Oh - I meant - design of the web site.. Adventureworks is very useful at times....

...and based on Antares' reformat - you might care to add on extra index per table covering each of the fields in the ON statement, and INCLUDE anything in the...

It's something SQL server doesn't care about - multi-homing is done at the OS level.

You want to figure out what traffic you can steer to "what" Network interface card.

K Currie (12/4/2007)

---

I'm trying to determine which query is better and when I say better, I mean will perform faster. I'm comparing data in two tables by using "not in"...

Make sure you follow the links through all of the way. The initial 2005 version link somehow takes you to the 2008 version of Aventureworks, with a second link...

Seems awfully long - sounds like something's missing.

neil (12/4/2007)

---

I also ran the query through the Query window in SSMS with "Include Actual Execution Plan" enabled. This showed that all the...

WILLIAM MITCHELL (12/4/2007)

---

And if I convert the db to Access 2000, the same script does work - just like you described.

Matt, do you actually have Access 97 installed? I don't...

Interestingly enough - I set up the linked server to use NO security context when it queries the remote server, so I don't set up the server login at all....

once you do that, an "old-style" pivot on a SINGLE table should do the trick:

select

prediction_date_startdate,

prediction_date_enddate,

sum(case when prediction_week_number=1 then running_prediction else 0...

Now this doesn't get you all of the way there - but it seems a lot simpler to create the running sums FIRST,

then worry about getting the laid out...

It also depends on what you call "additional languages". A lot of us play squarely on the OLTP side of the fence, leaving the analyticals, cubes, etc... largely alone....

Well - this is about the nature of your relationships.

First - you need to remember that a PK uniquely identifies each row. So, if a row in tableA can...

WILLIAM MITCHELL (12/4/2007)

---

Tyshdude, I think you stated the answer in your first post:

"Thinking it might be a problem with Access 97, I manually converted some test data up to Access...