CREATE   PROCEDURE dbo.up_AddRow(
@spa_Order nvarchar(50),
@sud_Order nvarchar(50),
@NRPL nvarchar(50)
)
AS
SET NOCOUNT ON;

/* Dichiaro una variabile di tipo TABLE
** dove inserirò la riga che vuoi aggiungere
*/
DECLARE @NewRow TABLE(
spa_Order nvarchar(50) NULL,
sud_Order nvarchar(50)NULL,
NRPL nvarchar(50)NULL
);

/* Popolo la tabella */
INSERT @NewRow VALUES(@spa_Order, @sud_Order,@nrpl);
SET NOCOUNT OFF;

/* Controllo */
IF EXISTS(
    SELECT *
    FROM @NewRow AS NR
    JOIN (
        SELECT spa_Order, sud_Order,NRPL_ShopOrder --TOP 5 spa_Order, sud_Order,NRPL
      FROM dbo.OSM_Ord
          -- ORDER BY [id] DESC
    ) AS T
    ON NR.spa_Order = T.spa_Order
    AND NR.sud_Order = T.sud_Order
    AND NR.nrpl = T.NRPL_ShopOrder
    )
     

        -- Esiste
        RETURN 1
ELSE
    BEGIN
        -- Non esiste

        INSERT INTO dbo.OSM_Ord(SpA_Order,Sud_Order,NRPL_ShopOrder) VALUES(@spa_Order, @sud_Order,@NRPL)
        RETURN 0
    END