Are there performance advantages that can be achieved by wrapping a complex SELECT into a stored procedure?
Alex