Interesting, because I had thought that any function that took no parameters or a hard coded value parameter would only be evaluated once and would return the same value for...

Here's the deadlock graph from one of the occurrences.

I think a light is starting to come on - what I was looking at as a simple read query with a...

More info:

I was using a Derived Column transformation to cast a datetime value from my source database to DT_DBDATE and then lookup the value on a date datatype field in...

I have the same problem. I have a DimDate dimension with an integer datatype primary key and a unique index date datatype as the business key / alternative key. Whenever...

Figured it out. Many of our stored procedures use dynamic SQL, like {Exec('string query')}. Of course, these execute in a separate batch as the calling user and don't inherit anything...

I do much the same thing in defining standardized colors for different sections of reports, except I use parameters to hold color definitions instead of custom code. For instance, I...

Thanks much! OLAP PivotTable Extensions worked great.

Chuck Bevitt

Thanks for your help. The ‘BIDS Helper’ is a great recommendation.

I already have books (and print-outs from Microsoft Books Online); unfortunately, most authors can’t see the forest for the trees....

Here's the answer - but it's klugey!!

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=915156&SiteID=17

If you want multiple detail lines to stay together on the same page, you have to create ONE detail line, that contains...

Thanks to all who responded. Hopefully, I might hear some more back.

While TIFF is a native Reporting Services rendering type, "TIFF" is not a single, atomic specification. There are many...