USP_SIMPLEDATALIST_CREDITREFUNDABLETICKETNUMBERS

CREATE procedure dbo.USP_SIMPLEDATALIST_CREDITREFUNDABLETICKETNUMBERS
(
    @SALESORDERITEMTICKETID uniqueidentifier = null
)
as
    select 
        ID as VALUE,
        TICKETNUMBER as LABEL
    from dbo.TICKET
    where SALESORDERITEMTICKETID = @SALESORDERITEMTICKETID