<--- --------------------------------------------------------------------------------------- ----
	
	Blog Entry:
	SQL ISZERO() And NULLIF() For Dividing By Zero
	
	Author:
	Ben Nadel / Kinky Solutions
	
	Link:
	http://www.bennadel.com/index.cfm?dax=blog:473.view
	
	Date Posted:
	Jan 15, 2007 at 3:23 PM
	
---- --------------------------------------------------------------------------------------- --->


(
	CAST( SUM( r.price ) AS FLOAT ) /
	(
		SELECT
			dbo.ISZERO( SUM( r2.price ), 1 )
		FROM
			reward r2
		INNER JOIN
			[order] o2
		ON
			r2.order_id = o2.id
		WHERE
			o2.user_id = u.id
	) *
	100
) AS percentage_used