Okay, I think I have it now... one option is to filter all the "required" and single-value parameters in the stored procedure, and then filter the multi-value parameters in the...

So I don't even need the DelimitedSplit functions for this, because that's what removing the "(0)" does. ... I think.

Scott,

thanks for that. I'm pretty sure I read your article before doing this... that's maybe where some of the idea came from.

One question though... when you remove the subscript...

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