Often times I get to write calculations where the it is necessary to divide one value from another. Simple little math equations. But in many of these cases, the denominator has the chance to be valued at zero (0). And for these, I usually write my SQL statements similar to the following: A simple case … Continue reading Divide By Zero
Month: August 2007
Word Up, Disable Reading Layout
If you are anything like me or anyone I know, then you hate the Reading Layout that comes up in Word. Yes, it's been there a while and I've been hating it all along. Kind of like that annoying drip from the bathroom faucet. Today, I took the time out to figure out how to … Continue reading Word Up, Disable Reading Layout
Reporting Services Resources
I honestly could have sworn up and down the church aisle that I'd posted something in these a few months ago. Obviously, wires got crossed either in the real world or the nether of my mind. But long story short, here are a couple great resources to use when building reports using Reporting Services. SSW … Continue reading Reporting Services Resources
Identify Reporting Services Version and Edition
While trying to identify the reporting services edition installed on a server today, I found quite a few ways to identify both the edition and version of reporting services. And now they are listed below from various news group threads for your reading pleasure. The version of an installed reporting services service can be found … Continue reading Identify Reporting Services Version and Edition
Strate SQL 