Combined with the other suggestions, how about this?
WHEN ( Number_Deleted_Rows = 0 ) THEN 0
WHEN ( Number_Rows = 0 ) AND ( Number_Deleted_Rows > 0 ) THEN
WHEN Number_Rows = Number_Deleted_Rows THEN
ELSE (100 * Number_Deleted_Rows / ( Number_Rows +
Number_Deleted_Rows ) )
AS DECIMAL( 5 , 2 )
) AS Percent_Deleted
Might not even need the third WHEN.
"Contrariwise, if it was so, it might be; and if it were so, it would
be; but as it isn't, it ain't. That's logic."--Tweedledee
On 09/16/2013 2:40 PM, Scott Mildenberger wrote:
Your first two whens can be combined into one
WHEN Number_Deleted_Rows = 0 THEN 0
Also, your very last when doesn't return 'Percent deleted', consider 1 Row and 5 deleted. Returns 20%. The more deleted the smaller the percent, is that what you really want? You may be able to use the when before that as an ELSE catchall.
Davis Transport Inc.