That is brilliant.

I tried everything.... except that. No idea why i didnt try it.

When i get a second i am going to sort this into a stored...

Thanks for that.

I still have an issue - maybe i wasnt clear with my definition.

I want this to compare two SP results on different servers. Not two specific SP`s.

So...

Hugo Kornelis (4/13/2012)

---

danielfountain (4/13/2012)

---

I am confused.

How come this is supposed to bring back 6 rows?

select top 5 with ties * from SSCSales order by cMonthSales desc

There are 4 records with...

I am confused.

How come this is supposed to bring back 6 rows?

select top 5 with ties * from SSCSales order by cMonthSales desc

There are 4 records with 3500. So...

I need to start canvassing votes I think!

🙂

Posting the link helps

https://connect.microsoft.com/SQLServer/feedback/details/253976/add-style-or-stylesheet-or-template-to-reporting-services-reports

Seems like i have been beaten to it a few times over.

This one seems to have the biggest following for anyone wishing to vote (please do!)

Dan

WOW!!!!

Time to do some more reading up on that. It seems to make it go quicker (or the same speed - depending on when run) as the original query.

Thanks...

Thanks all for your advice.

Taken on board and working on a solution.

Hi,

The reason i need this is not that i am actually going to change the format - but i...

vk-kirov (3/1/2012)

---

Nice question, although the 'explanation' is confusing and does not explain anything.

To find the real cause of the observed behavior, we can do a simple conversion. The statement

s.Stat NOT...

Thats great. Thank you!

I presume i would be equally ok by raising the error but with a severity under 10?

Dan

Hugo Kornelis (2/17/2012)

---

danielfountain (2/17/2012)

---

Hugo Kornelis (2/17/2012)

---

Nice, easy question - though I'm sad that as of this time, 8% of respondends got it wrong.

There is an error in the explanation, though....

Hugo Kornelis (2/17/2012)

---

Nice, easy question - though I'm sad that as of this time, 8% of respondends got it wrong.

There is an error in the explanation, though. You can not...

Good question - i got it right.

But surely without running the code there would be no output :0)

(Above is tongue in cheek)