• 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)

2006-07-28 (first published: )

3,862 reads

Blogs

Recovering a TDE Database Without the Certificate 

By

If you don’t have the backups of the certificate and private key from the...

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

Read the latest Blogs

Forums

VSS / SQLWriter sequence of warnings and error (... subset of the volumes ...)

By Johan Bijnens

We have (only) one SQL2019 clustered instance reporting this sequence of error and warnings:...

The Data Fabric – Future of Data Management

By Ajay Kumar

Comments posted to this topic are about the item The Data Fabric – Future...

The Rise of Vector Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Rise of Vector Databases

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers