Have you checked other reports running on that same SSRS instance?

Do those same reports access the same database with the same data source as the failing report?

Are these reports running...

Andy -

I have worked for multiple companies over the course of my career. Some had "lunch rooms" (basically really large break rooms), some had cafeterias, one actually even...

+1 on the interesting solution. I like the core approach of looking at the "predecessor" outside of having a integer delimited list. I have used something similar in...

Without getting into datatype questions (as to if the XXX means numeric data or not), sounds like you need a CHECK constraint:

http://technet.microsoft.com/en-us/library/ms188258%28v=sql.105%29.aspx

+1 to this reply but I would like give props to the question author

This question was pretty simple for me... only because I tried this method of updating the primary keys late last week. My solution was no where even as...

Fellow SSC'ers,

David's post was exactly what I was looking for! I was looking at the complete data set incorrectly (which was a bad assumption since every decision after that...

There will be 1 S and 1 E record for each compartment. The "corresponding" A record will only exist if the compartment was measured. So even if there...

First off, I want to say how much I do appreciate those of you who are helping me.

Secondly, I do apologize if I performed an epic-fail on trying to...

My apologies. That row shouldn't be returned as 1200.0 but as 2500.0. I can completely understand the confusion.

The logic is where document type (doc_type column) is 'S' for...

pangeia

The company I was working for at the time was fairly large and after the incident I had plenty of opportunities to re-tell the story. It happened as I...

Thank you for the suggestions. I am interested in testing out the different suggestions you make on my test data set (200 million rows).

I can always rely on SSC...

Thank you Luis. <insert facepalm here/> That was exactly what was in UDF, I guess thats what I get when I assume.

As a minor suggestion, you could try wrapping entire script in a single named transaction and then continue using another named transaction for the "work". You could commit the...