Hi!
Make it in 2 commands:
UPDATE ... WHERE {condition to select records just for update}
INSERT ... WHERE {condition to select records just for insert}
Update can scan on table and update anotehr table, the same is for INSERT. INSERT command also can use SELECT statement to get records data for inserting.
>As I can understand an user defined function doesn't allow the user to use either a call to a stored procedure, or a table update or a table insert. Is there a way around this problem?
>For each row in a table I would like to call a proc (that will either update or insert another table), but I do not want to use a cursor. Any suggestions?
>
>Regards
>Jenny
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.