>> If (:In_vin = :Out_BikeLast8Vin) then BEGIN
>> Update Total_sales_to_part_cost_match
>> set TSPM_BIKEYEAR = :Out_BikeYear,TSPM_BIKEMAKE =
>> :Out_BikeMake, TSPM_BIKEMODEL = :Out_BikeModel, TSPM_LAST8VIN =
>> :Out_BikeLast8Vin;

>Given that your stored procedure will update (and return) at most one
>row (as far as I understand your domain) and this is something that
>changes data (instead of only producing rows), I would keep it an
>executable stored procedure and change the way you execute it.

Just a minor comment that's irrelevant to the original question: The update statement has no WHERE clause, so all records of Total_sales_to_part_cost_match will be updated.

Set