Function must return a value but in Stored Procedure it is optional