>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.
>

Sergey,

How do you use SP or UDF in an INSERT statement? Would you please provide some samples if it's not too much to ask?

Thanks a lot in advance.