Data Warehousing

Handle Divide by Zero in SQL Reporting Services

  • Script

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,767 reads

Frequency of each field in table

  • Script

This SP will generate the frequency of each occurrence in a field or for every field in a table. The syntax isexex sp_freqall , , , , for example:exec sp_freqall utems2000_2001, null,lastname, 100would return a table (with a field name and a count) for each field in the utems2000_2001 table, except the lastname field and […]

2002-10-03

221 reads

Blogs

SSIS Logging – Linking sysssislog with custom log

By

I was working on an ETL solution, which was expected to run for hours....

Azure Arc

By

Azure arc is another great stuff coming with Microsoft Azure, as we were expecting...

Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements

By

The next batch of exciting updates to the block editor is live on WordPress.com....

Read the latest Blogs

Forums

AOAG with FCI Step by Step

By Super Cat

It's been a very long while since I have set this all up. I...

how to get GPNSignature that first part on it start by portion key ?

By ahmed_elbarbary.2010

I work on sql server 2012 I face issue i can't get GPNSignature that...

Multiple .ndf file in single disk

By IT researcher

I have moved some of my database to SQL server 2017 (RTM) - Standard...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers