I was considering playing with JOIN (already used it to show the filter as a comma-separated list)... I'll give it a whirl and see what happens. The funny part...

Sorry about that...

http://www.brentozar.com/archive/2013/04/five-things-about-fillfactor/

If this is part of routine maintenance, did you check out Ola Hallengren's script? (It's here somewhere, and it works.)

To quote someone smarter than I, "At an individual index level by specifying fillfactor when you create or rebuild the index."

Read this article: Brent Ozar's take on Fill Factor

if you're not writing directly to the final table, you could use a SELECT DISTINCT instead of a plain SELECT and it would remove duplicates for you. It's more...

he wasn't being snarky or anything like that.

he was just trying to point out that you need to provide enough information for the people here to understand your problem (your...

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...