I like what...

The good news is I still learned something very valuable and ultimately found a more credible resource.

This is the simplest and most straight forward example for gaps and islands that I have ever seen. Thank you VERY much for posting.

It's been a while but I may have seen this and it was when I was using multi-valued parameters and queries to pull the available parameter values. It turned...

Sometimes at home I want to talk about something technical I did at work because I’m excited about it or simply because articulating it helps me remember or understand it...

Thanks, Cadavre, for the very comprehensive response. If...

Thanks, Nevyn. I'm still inclined to think of any select within a select as a subquery but let me take that idea and run with it.

Thanks for the responses and they both tell me “what”. I am after the “why”.

This reminds of the late 70s, early 80s when car manufactures started making their products largely unserviceable by what we called “service stations” back in the day (see many of...

That is one of...

I'm not a .NET programmer but my understanding is that .NET applications (which SSRS would be) compile at run time. That may figure in here somewhere.

Thanks for the response, Lynn. The software was installed by someone else but I was unaware that using a named instance would create this issue so I wouldn't have...

It is very easy enable report errors as well. Not sure if you have to start and stop the service, though.

http://msdn.microsoft.com/en-us/library/aa337165(v=sql.105).aspx

To me this is an very interesting editorial and I'm a bit shocked that there aren't about five pages of comments by now instead of a single (and thoughtful) post....

I had a hunch that I was going to need to go this route. Thank you for the very practical advice.