Dichiarare tabella definita utente

CREATE TYPE TABELLADEFINITAUTENTE AS TABLE 
( Idcategoriemercsub INT )
GO
CREATE PROCEDURE sp_ArticoliVendita_SelCat
  @idcategoriemercsub TABELLADEFINITAUTENTE READONLY
as
BEGIN
SET NOCOUNT ON;
-- Insert statements for procedure here
    select  idarticolivendita ,
        codice,
        descrizione 
  from articolivendita 
  inner join @idcategoriemercsub A
  On     A.idcategoriemercsub  = articolivendita.idcategoriemercsub
  order by articolivendita.descrizione Asc
END

SELECT * FROM products WHERE id IN (SELECT ... FROM ... WHERE...)