Since the SQL to return the records you want is really simple, I would just join this...

SELECT r.jobnumber

re.code

FROM repheader r

INNER JOIN repairtype re ON re.code = r.code

to your other query....

use a cartesian product. (two tables in the query, no join). One has People, one has Events. No join means the tables get multiplied. Filter as...

You're missing the "Add 14 hours" part...

=DateAdd("h",14,DateAdd("d",-1,Today))

I'll give you that I'm not an SSIS guy, but if the format is always the same, you should be able to create a variable for the filename, then strip...

absolutely reeks of a homework assignment.

If you can group by half hours, then you're golden. Try something like getting the number of half hours since midnight, and then grouping...

No. I was leaving out a bunch of stuff. It was the bare bones of a stored procedure. One of the differences between a view and a...

Are the pick lists for 3 possible values really necessary? Simplify, then you're done.

You could do this...

SELECT bioID

, FirstName

, LastName

, Sex

, Status

FROM Bio INNER JOIN Sex ON Bio.SexID=Sex.SexID

INNER JOIN [Status]

ON...

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.

http://blog.summitcloud.com/2010/01/multivalue-parameters-with-stored-procedures-in-ssrs-sql/

(apologies to...

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