Hi

any ideas why this is not working

I know that @NewIndividualRef and @NewwJointIndividualRef have valid keys in them
I've printed them juts before the statement to check
The update doesn't produce an error code. If enter the update staement outside the stored procedure it work ok.

Any ideas ?

thanks

begin try
update [test_nm].[dbo].[individual] set individual.family_ref = @NewIndividualRef where individual.individual_ref = @NewwJointIndividualRef

end try
begin catch

SELECT ERROR_NUMBER() AS ErrorNumber
end catch