USP_SIMPLEDATALIST_WORKSTATION_PRINTER

Lists the printers for a given workstation.

Parameters

Parameter	Parameter Type	Mode	Description
@WORKSTATIONID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_WORKSTATION_PRINTER 
(
    @WORKSTATIONID uniqueidentifier
)
as
    select 
        ID as VALUE, 
        WORKSTATIONPRINTER.[PRINTERNAME] as LABEL
    from dbo.WORKSTATIONPRINTER
    where WORKSTATIONPRINTER.WORKSTATIONID = @WORKSTATIONID
    order by WORKSTATIONPRINTER.SEQUENCE