Thanks

What about making use of the fact that it will always be inserting new records and very rarely having to Update exisiting

Would this Pseudo Code be better (if I could turn it into TSQL)

Try

INSERT INTO TBLCustomer (f1...) VALUES(v1...)

Catch

IF Error = 'Primary Key Validation'

UPDATE TBLCustomer SET F1=V1, ... WHERE CiD =1

ELSE

RAISEERROR -- Pass on non PK Errors

I thought SP were slighter faster because they were compiled, but from what I've read, it would seem in later editions of SQL Server this performance difference has gone?

I do agree with control/admin much easier with SPs/Views etc.