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

Looks to me like you're missing something. Is there no "Account" table somewhere? If you think about a bank account, at its simplest, it's something like:

CREATE TABLE Account(

...

#1: one way is to use a value list of the possible values. If you create a dataset of the values you can just use it.

#2. You can use...

Maybe you should have explained that to begin with.

Bite me.

Why not just filter the dataset?

Where do you get the data from?

You could transpose it in SSIS or Excel (that's what I used) and then it would be easy to use in SSRS. Then...

duplicate post! oops!

Okay, I think I got it...

Here's the stored procedure (I'm sure Dwain will school me on doing it this way, but I was just trying to get it...