UFN_DISBURSEMENTPROCESS_FORMATPRINTORDER

CREATE function dbo.UFN_DISBURSEMENTPROCESS_FORMATPRINTORDER(
  @DISBURSEMENTPROCESSID uniqueidentifier
)
returns table
as return
  select 
    DPD.ID as ID
    ,case DF.PRINTTRANSACTIONSORDERCODE
      when 0 then case DF.PRINTORDERCODE when 0 then row_number() over (order by C.KEYNAME ASC) else row_number() over (order by C.KEYNAME DESC) end
      when 1 then case DF.PRINTORDERCODE when 0 then row_number() over (order by FT.TRANSACTIONAMOUNT ASC) else row_number() over (order by FT.TRANSACTIONAMOUNT DESC) end
     end as SORTCOLUMN
    ,C.KEYNAME
    ,DF.PRINTTRANSACTIONSORDER
    ,DF.PRINTORDER
  from dbo.DISBURSEMENTPROCESSDISBURSEMENT as DPD
    inner join dbo.DISBURSEMENTPROCESSFORMAT as DPF on DPF.DISBURSEMENTPROCESSID = DPD.DISBURSEMENTPROCESSID
    inner join dbo.DISBURSEMENTFORMAT as DF on DF.ID = DPF.DISBURSEMENTFORMATID
    inner join dbo.FINANCIALTRANSACTION as FT on DPD.ID = FT.ID
    inner join dbo.VENDOR as V on FT.CONSTITUENTID = V.ID
    inner join dbo.CONSTITUENT as C on V.ID = C.ID
  where DPD.DISBURSEMENTPROCESSID = @DISBURSEMENTPROCESSID