Here's the whole function and stored procedure declaration etc, just in case someone else has this fun.

ALTER FUNCTION [dbo].[fn_SplitStringList]

(

@StringList VARCHAR(MAX)

)

RETURNS @TableList TABLE( StringLiteral VARCHAR(128))

AS

BEGIN

DECLARE @StartPointer INT, @EndPointer INT

SELECT...

Oh Super cool!!! Works a CHAMP!!! Definitely a good trick to learn! Thanks!

In case any other Reporting Services rookie comes across this, here's a really good article walking you through a solution and explaining what works and what doesn't and why.

Oh... must have missed that very subtle hint: TABLE-valued function. (So you query it, because it's a ... well, a TABLE!

Thanks!

I'm trying (in vain) to use the DelimitedSplit8K function to pass a delimited list to my stored procedure to filter my underlying resultset

Here's my SQL

CREATE PROCEDURE BuildDatesForReport

( @StartDate ...

Hard to say given the limited information. One thing would be to filter as much out of the dataset as early as possible (in the stored procedure, if possible)....

Erland,

That's what I was originally thinking - if filtering in SSRS only removes a few records, that's one thing, but if it removes potentially millions - why not remove them...

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