I don't know what else to tell you... same plan should give same results and pathway to results.

I've never seen that outside of having 2 plans cached.

Anyway you can reproduce...

please post the exact code you are using to call the sps.

...if one calls the sp like this exec usp_whatever

while the second one uses any variation dbo.usp.. Usp_

that will...

from bol 2008

COUNT(ALL expression) evaluates expression for each row in a group and returns the number of nonnull values.

COUNT(DISTINCT expression) evaluates expression for each row in a group and returns...

well 1/ null will surele give null if not an error.

also count(null) has a different behavior than you might expect... please read bol for the full details.

I would consider using the report viewer control since I've seen an app that we couldn't copy the data (other than typing it out).

I don't know how secure you need...

Do a search for concatenation in the scripts sections and you'll find what you need for that.

Now another problem you'll face is that you'll need to sort before you concatenate......

or another more manual way

step one.

Select username, MAX(CASE WHEN Permissions = 'user' THEN 'User' ELSE NULL END) As User, , MAX(CASE WHEN Permissions = 'reporter' THEN 'reporter' ELSE NULL END)...

Check out pivot in BOLs.

Once you've pivoted the data your resultset would look like

user, perm1, perm2, perm3....

Then it's only a matter of doing a group by all perms and counting...

First time I ever hear of that. Any article on how to do this?

What do you mean by deploy remotely?

I guess plan B would be to host the reports on our own servers but then we have to download the databases to our...

I was personally talking about the rdl definition... protecting against intellectual property theft. I know the data belongs to the client so I want him to be able to...

Who am I to decide that for you?

Why do...

That post from bru as the first reply would have taken the edge off my *** feeling :

Can I forward the links in the interview ?

There are a dozen...

It makes me laugh too because I now know he's kidding and that the poster is trying to screw with the system.

However if I'm a propfessional googling for an answer...

...maybe but the fact still remains, when you read that thread without knowing what's going on you look like jerks and it's not inviting at all.

I know you're totally right...