Could you post at least a partial table definition? It's hard to tell without an example.... so throw in a few insert statements too... enough so we know what...

If all you're looking at is fund prices over time, wouldn't that structure be more like this:

CREATE TABLE TickerPrice (

TickerID VARCHAR(10) NOT NULL,

SomeDate DATE NOT NULL,

...

Good to know, because I almost did that. (See, some of us are still noobs making admittedly dumb mistakes...)

SQL Saturday is awesome! I saw Denny Cherry (covering for someone else) do a super basic presentation with his hands in his pockets the whole time. Saw Rick...

Did you read Paul White's articles on the subject?

http://www.sqlservercentral.com/articles/APPLY/69953/

and

http://www.sqlservercentral.com/articles/APPLY/69954/

Kevin,

I'm really good at making T-SQL mistakes. Is the presentation posted somewhere so I can learn from someone else's mistakes instead of just my own?

Thanks!

Pieter

Just a thought... what if you used bcp or something to crank the resultset into either csv or Excel, and then used that as a source instead of the DB...

Wouldn't you use JET4.0 instead of ACE? ACE is the filetype for Access 2007 and beyond.

Cool! Thanks, Stefan!

Now to walk through it slowly (with the explanations) and see if I can learn to spot the pattern.

I think the fun part is the NOT EXISTS...

Here's a small subset of the data... that's actually intelligible. Apologies for any SQL errors.

CREATE TABLE #Course (

CourseID CHAR(7),

CONSTRAINT pkCourse PRIMARY KEY (CourseID));

CREATE TABLE #Prereq (

NextCourseID CHAR(7),

RequiresCourseID CHAR(7),

CONSTRAINT pkPrereq...

I must have munged the SQL somewhere... it's not omitting the "next" courses for which a given student has some but not all of the prerequisites.

Here's the SQL I have,...

okay, now to do something sane and create a subset of the two tables and make sure it works -- looks like it does, but I'm not sure yet. ...

So negate everything in parentheses, and then wrap a NOT around it (double negatives, my favorite!)

Makes sense... now, let me see if I can actually make it work!

Thanks!

Since the course level should be fairly static (well, unless the prerequisites for a course are changed), I figured I would change things a little and store the computed level....

LOL, thanks.

The funny thing was that I figured it out after posting a couple of times. I guess posting forces me to re-read a bunch of my code to...