CREATE TABLE Tally2 (n INT

CONSTRAINT Tally2PK PRIMARY KEY (n));

GO

DECLARE @num INT = 111

WHILE @num <=955

BEGIN

INSERT INTO Tally2(n) VALUES (@num);

SET @num = @num + 1;

END

GO

Could you please post the scripts for the two tables in the problem and enough inserts statements to recreate the problem you are having? If you ask a question and...

Does each customer have his own logo? is the logo stored in the database (in a VARCHAR(MAX) field)?

Not sure if it will work for you, but the easiest way would be to make a copy of the report and then in the copy, remove the filters. ...

TRANSFORM in Access does a pivot, but I'm not clear on what the pivot is even supposed to do in this case.

Could you post some original data (well the data...

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.