USP_DATALIST_WORKSTATION_PRINTER

Returns all Workstation Printer records.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_WORKSTATION_PRINTER
(
    @WORKSTATIONID uniqueidentifier
)
as
    set nocount on;

    select 
        WORKSTATIONPRINTER.[ID],
        WORKSTATIONPRINTER.[SEQUENCE] + 1 as SEQUENCE,
        WORKSTATIONPRINTER.[PRINTERNAME],
        (select max(SEQUENCE) + 1 from dbo.WORKSTATIONPRINTER where WORKSTATIONID = @WORKSTATIONID) as MAXSEQUENCE
    from 
        dbo.WORKSTATIONPRINTER
    where
        WORKSTATIONID = @WORKSTATIONID
    order by
        SEQUENCE