I like option 2 in this case. You can query the view and return the results you need. With the view, it gives you the option to use that view in several procs without having to rewrite the same code over and over.