USP_DATALIST_DOCUMENT_PRINTERS

Get the printers in the printer list attached to the given document.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_DOCUMENT_PRINTERS(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select PRINTERLISTITEM.ID,
           PRINTERLISTITEM.PRINTERNAME
    from dbo.DOCUMENT
        inner join dbo.PRINTERLIST on DOCUMENT.PRINTERLISTID = PRINTERLIST.ID
        inner join dbo.PRINTERLISTITEM on PRINTERLISTITEM.PRINTERLISTID = PRINTERLIST.ID
    where DOCUMENT.ID = @CONTEXTID