create procedure [dbo].[MssWebDeleteOrderContactPhone]
    @inContactId int,
    @inPhoneType varchar(50)
as
begin
    set nocount on

    ;with PhoneData as
    (
        select
        ContactId = @inContactId,
        PhoneTypeId = OrderContactPhoneType.OrderContactPhoneTypeID
        from OrderContactPhoneType
        where OrderContactPhoneType.TypeName = @inPhoneType
    )
    delete OrderContactPhoneNumber from PhoneData
    where OrderContactPhoneNumber.OrderContactFID = PhoneData.ContactId and
    OrderContactPhoneNumber.OrderContactPhoneTypeFID = PhoneData.PhoneTypeId
end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteOrderContactPhone] TO [MssExec]
GO