IF ELSE END

Run one of two queries depending in the parameter passed in.


@Type Varchar(10)

IF @Type = ’All’
	BEGIN
		SELECT * 
		FROM Recipients 


	END
ELSE
	BEGIN
		
		SELECT TOP 10 * 
		FROM vwRecipients
	
	END