ALTER PROCEDURE [dbo].[GetDataProductByInventario]
(
  @Order  nvarchar(50),
  @productName nvarchar(150)
  
)
AS
  SET NOCOUNT ON;
SELECT     productID , productName, sku, ourPrice, retailPrice, manufacturer, categoryName, status, Disponibilita
FROM         vwProduct
WHERE     (Disponibilita > 0) AND (productName LIKE '%' + @productName + '%') 
Order By CASE @Order 
             WHEN 'productID' THEN productID 
             WHEN 'productName' THEN productID 
             WHEN 'sku' THEN sku 
             WHEN 'ourPrice' THEN ourPrice 
             WHEN 'retailPrice' THEN retailPrice
             WHEN 'manufacturer' THEN manufacturer 
             WHEN 'categoryName' THEN categoryName
             WHEN 'Disponibilita' THEN Disponibilita
         END