• 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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(14)

You rated this post out of 5. Change rating

2006-07-28 (first published: )

4,039 reads

Blogs

Fighting Procrastination?

By

Here is another short video (~ 15 minutes). This is by the author of...

A Fun Prize at the PASS Data Community Summit

By

I had a briefing for the 2026 PASS Data Community Summit, which is just...

How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents

By

Your AI is busy. But do you know what it's worth? Most companies can...

Read the latest Blogs

Forums

Alamat BCA KCP Banjaran Adiwerna Telp +62 821-6277-387

By Layanan Bank BCA

Jl. Raya Utara Adiwerna No.304, 306, Pejagan, Adiwerna, Kec. Adiwerna, Kabupaten Tegal, Jawa Tengah...

Alamat BCA KCP Kemanggisan Telp +62 821-6277-387

By Layanan 24jam

Jl. Kemanggisan Utama Raya No.37, RT.7/RW.8, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...

Inventory Snapshot for missing Period

By getsaby

Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....

Visit the forum

Question of the Day

SQL Server Vector Support I

What are vectors in SQL Server 2025, as related to the new AI features?

See possible answers