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?