UFN_SALESORDER_GETDETERMINISTICCOMBOTICKETNUMBERS

create function dbo.UFN_SALESORDER_GETDETERMINISTICCOMBOTICKETNUMBERS
(
    @SALESORDERID as uniqueidentifier
)
returns table
as return (
    select
        COMBOITEM.TICKETCOMBINATIONID,
        TICKET.ID TICKETID,
        row_number() over(partition by COMBOITEM.TICKETCOMBINATIONID, COMBOITEM.PROGRAMGROUPID order by TICKET.PRICETYPECODEID, TICKET.ID) TICKETGROUPNUMBER
    from dbo.TICKET
    inner join dbo.SALESORDERITEMTICKETCOMBINATION COMBOITEM on COMBOITEM.ID = TICKET.SALESORDERITEMTICKETID
    inner join dbo.SALESORDERITEM ITEM on ITEM.ID = TICKET.SALESORDERITEMTICKETID
    where ITEM.SALESORDERID = @SALESORDERID
);