> Thanks Sasha, i'm already using a stored procedure, to insert or update an =
> item in a stock table.
> Just now, i'm doing a select to find if the records exists and do the corre=
> sponding insert or update the quantity of stock.=20
> I think that the new syntax could be more simple and clear, with few lines =
> of code.

Use MERGE for this task

Regards,
Vlad