USP_DATALIST_PRINTER_LIST

CREATE procedure dbo.USP_DATALIST_PRINTER_LIST
as
    set nocount on;

    select 
        PRINTERLIST.[ID],
        null as [PRINTERLISTID],
        PRINTERLIST.[NAME],
        PRINTERLIST.[DESCRIPTION],
        1 as [ISPARENT]
    from 
        dbo.PRINTERLIST

    union all

    select
        ID,
        PRINTERLISTID,
        PRINTERNAME as NAME,
        null,
        0 as ISPARENT
    from
        dbo.PRINTERLISTITEM

    order by
        NAME