Untitled

CREATE PROCEDURE GetBugDetails(@Category nVarChar,@Alert nVarChar OUTPUT)ASSELECT BugID, Severity, Priority, Owner, State, Result, Summary, VotesFROM bugsWHERE Category = @CategorySELECT @Alert = IF(Severity < 3) {	return 1}else if(Severity > 3 < 7){	return 2}else{	return 3}