CREATE TRIGGER TR_SATIR_DESCRIPTION2
ON INVOICE
AFTER INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE II
    SET II.DESCRIPTION2 =
        CASE 
            WHEN AC.STOCKCODEACT IS NULL OR AC.STOCKCODEACT = ''
                THEN ISNULL(SB.BARCODE,'')
            ELSE AC.STOCKCODEACT + ' - ' + ISNULL(SB.BARCODE,'')
        END
    FROM INVOICEITEM II
    INNER JOIN inserted I
        ON I.COMPANYID = II.COMPANYID
       AND I.CPERIODID = II.CPERIODID
       AND I.RECEIPTID = II.RECEIPTID

    LEFT JOIN ACTSTOCKCONT AC
        ON AC.COMPANYID = I.COMPANYID
       AND AC.ACTID     = I.ACTID
       AND AC.STOCKID   = II.STOCKID

    OUTER APPLY (
        SELECT TOP 1 BARCODE
        FROM STOCKBARCODES SB
        WHERE SB.COMPANYID = I.COMPANYID
          AND SB.STOCKID   = II.STOCKID
		  AND SB.BARCODETYPE = 2
        ORDER BY SB.ITEMNO DESC
    ) SB

    WHERE I.COMPANYID = 11
      AND I.TRANSTYPE = 101;

END
GO