I have the need to grab some records from 3 tables to do a lengthy process which includes looping that resulting query doing some seeks, etc. I am thinking that since this involve 3 tables that I could create a parameterized view in the DDT and then create a BO based on this view, now here is the question: How to fill this BO and pass the parameters to the view?



If you can post a quick seudo code I would really appreciate it, or if it is a better, easier solution that does not required to use a view, I am more than happy to listen.



I am thinking on using a BO to take advantage of the BO features for Seek, Order, etc, since I may need to loop through this data several times.



Thanks!

Edhy Rijo

Hi Edhy,



I don't use the DDT so I don't know what facilities it offers but, within SQL Server, there is no such thing as a parameterised view. I believe you will be forced to use a stored procedure. However, I do remember seeing references to a creature called an 'inline function' that apparently can operate like an a parameterised view - I guess an inline function may be useful when stored procedures are not an option for some reason.



Cheers, Peter