Hmm... wondering where my post went... Turns out I did the thing wrong. 😀

The way I got it to work was to create two datasets - one of the...

I know this is a super old post, but I just thought I would update this a little, in case there's some other person out there in my place.

While Rob...

I am trying to get a count of lead_ids where row_description value is "Leads Referred" and DIVIDE that by count of lead_ids where row_description value is "All Leads"

KK,

I did something...

This article might give you some ideas... Partitioning in SQL Server[/url]

It sounds like this is a good use for it, but I'm not a partitioning expert... and it depends on...

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