OK, the configuration error was a red herring, I hadn't ordered the query to show timestart descending so was looking at the first handful of runs while we sorted out...

Going through the execution log in the report server I've found that all the executions since the problem surfaced have had a status of "rsServerConfigurationError" and all the times for...

and before anyone else says it, Yes, I should have been following my own motto! 😉

For my part, this was caused by a conditional split failing, my condition was evaluation to NULL when comparing date of payment to the SCD valid from date on SCDs...

On a related subject (I'm digging around in the catalog table at the moment) does anybody know what "Dynamic Prompt" relates to in the parameter field?

it is entrenched in the...

Minor correction on type 3, this is any other file type (xml, image etc.)

Hi, you can reference report items like cells in a tablix using something like !reportitems("item_name") I'm writing on my phone so cannot check the exact format right now.

So if...

For me my great escape is cooking, which is fantastic as I get the opportunity to do it every evening to feed my family (though it is far from unknown...

Hang on a minute ...

"Even though the IDENTITY property is intended to be used for key columns, SQL Server will not automatically generate a constraint to enforce the uniqueness,...

Absolutely agree, much better to hear from someone quietly that you've made a blooper and even though that initial conversation can (and prob will) be awkward it is perfectly possible...

Personally, my response to requests of that type has always been to try and say yes. Though it has backfired a little, on more than one performance appraisal I have...

I've been to the last two of these events and can say they are absolutly fantastic. And better yet the early bird discount for the training day and premium Friday...

I've been going to SQL Bits since number 3, they are fantastic. I actually enjoy them more and feel I learn mor from them that the paid for conferences. At...

Oh, how that sooo rings true, the number of times my Mother in Law has invited us to dinner, and somewhere in the phone call the words "My laptop wont"...

As a BI developer with a handful of DBA responsibilities too and having been paid well under the market rate for the last 4 years I would love this! Though...