The line in there that would worry me is this one:

Scalar UDFs are generally accepted as one of the worst things you can do performance-wise in T-SQL. However, they may...

you could add a calculated value to your dataset that did the calculation "row-wise" and then use that calculated value in your SUM / aggregate expression

you could add a calculated value to your dataset that did the calculation "row-wise" and then use that calculated value in your SUM / aggregate expression

FWIW, I started with Brian Larson's book on SSRS 2008. It was okay. He walks you through setup, which helps. Also, his instructions are usually really easy to...

I think you can use it. The best way to find out is to use a "sandbox" database (or something you can mess up and it won't matter), and...

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