"MackS" <ma***@yahooa.com> wrote in message
news:OWiNi8H$FHA.228@TK2MSFTNGP12.phx.gbl...
> Hello
> I am trying to create a stored procedure to move a ROW from Table1 to
> Table based on a coditon.
>
> Eg. I want to transfer an item with ITEMNO = '001202' FROM currentstock TO
> old_stock table.
>
> I want to be able to pass the value for ITEMNO from my code which calls
> the SP.
>
> Please help me
>
> TIA
>
> Mack
>
>