table_type_parameter.sql

CREATE TYPE [dbo].[PrimaryKeyINT] AS TABLE(
    [id] [int]
)

GO

CREATE PROCEDURE [dbo].[usp_GetDetails]
(
    @inClause PrimaryKeyINT READONLY
)
AS
BEGIN
    SELECT InventoryID, Product, [Date], Cost
    FROM InventoryHistory
    WHERE InventoryID IN (SELECT * FROM @inClause)
END