You can't call an SP from a view. YOu'll need to use SQL Passthrough.


>I have a function call that I need to denormalize data in a separate table.
>
>I now have that as a SP that I want to call like :
>exec dbo.depIndxPage ?vp_page
>
>
>CREATE PROCEDURE dbo.depIndxPage
>@page varchar(15)
>AS
>select dbo.GetTeeth(pi_applpg) as label , dbo.depindx.*
>from dbo.depindx
>GO
>
>
>I will get from 1 -> 1000 rows back.
>
>I want to use this like a NON UPDATEABLE view. Do I create a method in a bizobject for this repeat call like a requery() or is there a better way to implement this?