• I can understand why you can't make this a view, but what error are you getting when trying to create a stored procedure, and please post the code you tried to create a stored procedure.