SQL存储过程添加值并在达到最大值后停止

I would like to write a SQL query (SQL Server) that will return rows (in a given order) but only up to a given total. My client has paid me a given amount, and I want to return only those rows that are <= to that amount. I would like to write a SQL query (SQL Server)