UFN_TICKET_GETNEXTACTIVE

create function dbo.UFN_TICKET_GETNEXTACTIVE(@TICKETID uniqueidentifier)
returns uniqueidentifier
as begin
    declare @NEXTACTIVETICKETID uniqueidentifier;
    declare @SALESORDERITEMTICKETID uniqueidentifier;

    select @SALESORDERITEMTICKETID = SALESORDERITEMTICKETID from dbo.TICKET where ID = @TICKETID;

    select top 1
        @NEXTACTIVETICKETID = TICKET.ID
    from
        dbo.TICKET
    where
        TICKET.ID <> @TICKETID
        and TICKET.SALESORDERITEMTICKETID = @SALESORDERITEMTICKETID
        and TICKET.STATUSCODE = 0  -- Active

        and TICKET.SCANDATEWITHTIMEOFFSET is null
    order by
        TICKET.TICKETNUMBER;

    return @NEXTACTIVETICKETID;
end