Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master" or...

Thanks for the important article Steve.

A while back, my boss was good enough to ask if it was too noisy in my area and I appreciated that. ...

I can't answer your questions, but Paul Randal wrote about them some today on TechNet (scroll down on the site to the "Reduce I/O, Increase Performance" section): (http://technet.microsoft.com/en-us/magazine/hh334997.aspx)

So, apparently, the answer is not merely "No," but no one even cares! :w00t:

Thank you opc.three, I'll pass that along.

Ninja's_RGR'us (7/20/2011)

This will replace all double spaces with a single space....

Ninja's, what's the benefit of the WHILE there? I would have skipped that, but I'm probably missing something.

When the Space Shuttle lands, everybody wear ape suits, pass it on.

Steve, I hope you at least bought the horse a drink before hand.

Also a guess, but SSRS can be particular about formatting. Are the last four columns missing? If so, it may be that you need to choose a different...

That's odd, my screen shows a lot more than yours. Using IE8.

I think he's talking about extra lines in the code block rather than to the right of the code.

It looks like your using a JOIN for a WHERE clause.

If so, try replacing the JOIN with

instead of using a JOIN.

By the way, if...

The biggest concern is using that function on your last JOIN. Can you find another way to accomplish the same thing?

Please show us the code you have so far. Also, a sample of the data would be helpful.