When it is advised to use views and when selectable stored procedures?
views can't have params ;)
In my case there is table, which will grow in future (thoudsand's of
records), so I select at first only ID, name & surname. Then there is a
need to edit such record, M/D relationship is used (however, scrolling in
grid is slow then there is M/D relationship)

At 2003-11-30 23:46, you wrote:

>Still, implementing a M/d relationship between a table and itself (without
>a self-referencing F/K structure) is liable to cause weird updating
>problems whichever way you go, since you're updating the same record
>simultaneously from two datasets. I'd be questioning why you are doing this.

--/ Gediminas /--
The Truth Is Out There