CREATE PROCEDURE ProductPromotion_Select@ProductID intASSELECTProductID,ProductName,SUBSTRING(Description, 1, 150) + '...'AS DescriptionFROM ProductsWHERE ProductID IN(SELECT TOP 5 details2.ProductIDFROM OrderDetails details1INNER JOIN OrderDetails details2ON details1.OrderID = details2.OrderIDWHERE details1.ProductID = @ProductIDAND details2.ProductID != @ProductIDGROUP BY details2.ProductID)