gistfile1.sql

--@max_other_orders is a parameter to stored proc
select top (@max_other_orders)
    OH.SalesOrderID,
    OH.CustomerId,
    OH.SalesOrderNumber,
    OH.Status,
    count(*) over(partition by OH.CustomerId) as OtherOrdersCount
from Sales.SalesOrderHeader OH
where
    OH.CustomerID = @customer_id
    and OH.SalesOrderID <> @current_sales_id
order by OH.OrderDate