• Could you please post your stored procedure code?

    Without seeing what you can see it's hard to provide relevant help. Please read an article from the link at the bottom of my signature about this forum etiquette.

    From your very vague description, I can only guess that you have to choices:

    1. Create a separate stored proc which only performs UPDATE

    2. Amend the existing one to have input parameter as a flag which will determine its behaviour.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]