CREATE PROCEDURE GetBugDetails
(@Category nVarChar,
@Alert nVarChar OUTPUT)
AS
SELECT BugID, Severity, Priority, Owner, State, Result, Summary, Votes
FROM bugs
WHERE Category = @Category

SELECT @Alert = IF(Severity < 3) 
{
	return 1
}
else if(Severity > 3 < 7)
{
	return 2
}
else
{
	return 3
}