USP_DATALIST_DOCUMENT

CREATE procedure dbo.USP_DATALIST_DOCUMENT
(
    @SHOWINACTIVE bit = 0
)
as
    set nocount on;

    select ID,
           REPORTCATALOGID,
           case
            when TYPECODE = 0 then
                ''
            else
                cast(SEQUENCE as nvarchar(5))
            end
            PRIORITY,
           NAME,
           TYPE,
           dbo.UFN_TRANSLATIONFUNCTION_REPORT_GETNAME(REPORTCATALOGID),
           ISACTIVE,
           dbo.UFN_TRANSLATIONFUNCTION_PRINTERLIST(PRINTERLISTID) PRINTERLIST,
           DESCRIPTION,
           (select max(sequence) from dbo.DOCUMENT D where D.TYPECODE = DOCUMENT.TYPECODE) MAXPRIORITY,
           TYPECODE
    from dbo.DOCUMENT
    where @SHOWINACTIVE = 1 or ISACTIVE = 1
    order by TYPE, SEQUENCE