[dbo].[MssWebDeleteOAndILocalServiceLocationMapping]
create procedure [dbo].[MssWebDeleteOAndILocalServiceLocationMapping]
@inOrderId int,
@inLocalServiceId int,
@inLocationId int
as
begin
set nocount on;
delete LocServOrderLocationMap from LocServOrderLocationMap
inner join LocServ on LocServ.PriKey = LocServOrderLocationMap.LocServFID and LocServ.OrdPriKey = @inOrderId
where LocServOrderLocationMap.LocServFID = @inLocalServiceId
and LocServOrderLocationMap.OrderLocationFID = @inLocationId;
end
GO
GRANT EXECUTE ON [dbo].[MssWebDeleteOAndILocalServiceLocationMapping] TO [MssExec]
GO
