USP_DATALIST_WORKSTATIONCASHDRAWERSETTINGS

CREATE procedure dbo.USP_DATALIST_WORKSTATIONCASHDRAWERSETTINGS(
    @WORKSTATIONMACHINENAME nvarchar(255) = null)
as
    set nocount on;

    declare @WORKSTATIONID uniqueidentifier = dbo.UFN_WORKSTATION_GETIDBYMACHINENAME(@WORKSTATIONMACHINENAME);

    if @WORKSTATIONID is not null
    begin
        select
            1 OPENDRAWER,
            WORKSTATIONPRINTER.PRINTERNAME,
            WORKSTATION.CASHDRAWEROPENCOMMAND
        from dbo.WORKSTATION 
        left outer join dbo.WORKSTATIONPRINTER on
                WORKSTATION.CASHDRAWERPRINTERID = WORKSTATIONPRINTER.ID
        where WORKSTATION.ID = @WORKSTATIONID
    end
    else
        begin
            select
                0,
                '',
                ''
        end