OK, I guess this is where you are.

Try this:

SELECT

w.Season

, w.Week

, p.Player

, Case When w.Game1...

Nice!

If you would care to see the VB code that...

To be honest, I've kind of lost track of where we are on this: What are you looking for next from us?

As for the VB code: go ahead and...

Jeff Moden (10/25/2008)

---

Parul Sharma (10/24/2008)

---

I can tell you the answer to that... Seth's will handle a million rows in less than 7 seconds... the others that use a "triangular join"...

Oh, and you should supply the DDL for the Section table also, as that will probably be necessary for this discussion.

This seems like a simple matter, but it actually one of the more notorious traps of client-server programming. Because in fact there is NO simple one-record solution to this...

Let us know if you find out what the answer is. 🙂

WILLIAM MITCHELL (10/25/2008)

---

I'm not in favor of changing the order of columns, but it is possible.

It is very easy to change the order of the columns in SSMS if you...

Will it work? Yes. Is it the best design? Hard to say with so little information but probably not...

...

SSC Journeyman:

I suspect that you either need to set some options on the command or query the index scripts as a separate set of items. Either way...

What transformations are or are not valid has nothing to do with what data is actually in the tables, only with what data could possibly be in the tables. ...

right-click on the graphics pane and select "Properties", click on the General tab and change the interval. The time span is always 100 * the interval.

Yes you can change the interval from 1 second in Performance Monitor.

I don't follow?