• Interests: My family, Photography, Lego, Origami and paper Planes and of course database technology

Technical Article

Handle Divide by Zero in SQL Reporting Services

Out of the box, Reporting services does not handle divide by zero conditions gracefully. There are plenty of posting on how to use the IIF() function to accomplish this, with some rather horrific looking code. In order to simplify the coding process and make the resulting expressions readable by a mere mortal, I wrote the […]

4.5 (14)

You rated this post out of 5. Change rating

2006-07-28 (first published: )

3,984 reads

Blogs

How to Learn SQL Without Quitting Your Day Job

By

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...

Friday Flyway Tips: Chaining Commands for State-based Deployments

By

One of the cool things I’ve seen with the new Flyway CLI is that...

A New Word: Querinous

By

querinous – adj. longing for a sense of certainty in a relationship; wishing there...

Read the latest Blogs

Forums

standard deviation function doesnt seem to be behaving like an aggregate

By stan

hi i have 6 statistical populations in my overall data set.  They run across...

SQL Server Data...is it encrypted?

By water490

Hi Suppose someone gained unauthorized access to the physical SS data stored on my...

The Weather Outside Is Frightful

By Grant Fritchey

Comments posted to this topic are about the item The Weather Outside Is Frightful

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers