[dbo].[MssWebGetOrderSakariCustomContacts]
create procedure [dbo].[MssWebGetOrderSakariCustomContacts]
@inOrderId int
as
begin
set nocount on;
select
ContactId= SakariContact.SakariContactID,
ContactName= SakariContact.ContactName,
PhoneNumber = SakariContact.PhoneNumber
from SakariContactOrderMap
join SakariContact on SakariContact.SakariContactID = SakariContactOrderMap.SakariContactFID
where SakariContactOrderMap.OrderFID = @inOrderId
end
GO
GRANT EXECUTE ON [dbo].[MssWebGetOrderSakariCustomContacts] TO [MssExec]
GO
