This is a good solution if you can have 'nonsense' data. Our testers/UAT object to that on the whole. We've gone in for randomly combining realistic data - having a set...

If I understand this correctly, you want to show all the rows from your table, plus an option showing literally the word "ALL"?

This is quite easy as long (as you...

Greg Edwards-268690 (1/23/2014)

---

chris.smith 91049 (1/23/2014)

---

Of course, what IS a good practice, when its a reporting solution, is to develop properly a high quality data cube and give the Excel users...

Of course, what IS a good practice, when its a reporting solution, is to develop properly a high quality data cube and give the Excel users free rein when it...

Sure;

USE ReportServer

DECLARE @SubScriptionID NVARCHAR(50)

SELECT @SubScriptionID = [SubscriptionID]

FROM [ReportServer$SQL2012].[dbo].[Subscriptions]

WHERE [Description] = '<your subscription description here>: you can use any other criteria,...

I disagree with what a couple of people have said - that Excel itself isn't a problem - as a development tool it's terrible, not easily source-controlled, distributed code in...

Of course, there's an XKCD about this (as everything):

patrickmcginnis59 10839 (1/21/2014)

---

I think its awesome how sqlservercentral has solved...

"Guns...

FunkyDexter (1/21/2014)

---

I think we often forget that businesses don't exist to use our software or follow our procedures. They exist to deliver a product or service to a customer...

Well, it's horses...

Well, that sounds a little biased - Dev teams aren't just out to justify their budgets. Quite often they act sincerely where they see bad practice. The fact that the...