create procedure [dbo].[MssWebGetOrderNumbersByContactPriKeys]
    @inContactPriKeys IntList readonly
as
begin
    set nocount on

    select distinct
        SakariContactOrderMap.SakariContactFID as ContactPriKey,
        case
            when Orders.OrderNo is not null then Orders.OrderNo
            when Orders.Archived = 1 then Orders.ArchivedOrderNo + ' [A]'
            else dbo.FormatFirstNameLastName(Orders.FirstName, Orders.LastName)
        end as Identifier
    from @inContactPriKeys ContactPriKeys
    inner join SakariContactOrderMap
        on SakariContactOrderMap.SakariContactFID = ContactPriKeys.Item
    inner join Orders
        on SakariContactOrderMap.OrderFID = Orders.PriKey
    order by ContactPriKey, Identifier asc
end
GO
GRANT EXECUTE ON  [dbo].[MssWebGetOrderNumbersByContactPriKeys] TO [MssExec]
GO