Conditional SQL

gistfile1.sql

--	#	Conditional SQL Statements
--	This technique allows you to write a single query with conditional SQL without using the security hole of `EXECUTE`.

--	Skip The First Conditional
WHERE	1=	1

	--	Conditional SQL:	
	--		This technique allows you to write a single query with conditional SQL without using the security hole of `EXECUTE`.
	--		If @iUserStatusID is 0, then no limit is imposed.
	--		If @iUserStatusID is not 0, then Users.StatusID must equal @iUserStatusID.
	AND	Users.StatusID=	
		CASE WHEN	@iUserStatusID = 0
			THEN	Users.StatusID
			ELSE	@iUserStatusID

		END