Are you going to show the results of this in Reporting Services? (Yes, I know Jeff hates SSRS...)

If so, you don't need to do the Pivot in SQL Server --...

No need to shout... we can hear you fine.

You should read Jeff Moden's articles on crosstabs. Of course, if you're doing the crosstab in a report, you can just...

Have not tried it in 2014, but I wouldn't think so. Just back up and restore all the relevant databases, including msdb.

Did you include the primary key in the query?

I have done something like this before by creating a variable and populating it with the count of "people". Then you divide by that.

Use InStr() to find the parentheses, and then grab all the stuff in the middle. InStr returns a position (a number), so you can use it with Mid().

Don't want to do your homework for you, so I'll ask a question instead.

What's the conventional way of breaking up a many-to-many relationship?

Good point, Luis. Posting a question like this in an integration services group just made me wonder. Hence my question.

Okay, what version of SQL Server are you using, because this has zero to do with SSIS? This works in 2012, and I think in 2008.

This is a windowing...

wrap the IIF in a test for records? Maybe you can short-circuit it that way.

Freeze Top Row in Excel.

Not enough inserts to recreate the table data you're working on.

You REALLY need to read Jeff's article on how to get good help.

Please read this article.

Can you post the Create Table and INSERT statements to reproduce this? (Figured you would have figured that out already. You've been here for a while!)

Did you create the stored procedure by executing the code to create it? Something like...

CREATE PROCEDURE myProcName

@param1 VARCHAR(20)

, @param2 INT = 10

AS

SELECT field1, field2, field3

FROM MyTable

WHERE field1 = @param1

AND...

I have two tables one lists sites names while the other lists the completed tasks with the date of completion for the sites (the same site could have completed the...