An SP cannot be use in a query at all unless it's a part of INSERT INTO statement. Can you convert it into UDF() which can be used in a view.

>If I have an SP that does what I want, is there any way to get that to be the output of a view, in 2000? I want to see if there's a way in SQL Server that mightbe easier then the code changes I'm going to have to do if I use an SP vs. the view already used.