Re: Variable in LIMIT clause

[Matthew Grdinic]

I completely agree with how important/sweet this is/would be. I'm using stored procedure's with PHP right now and simply cannot find a clean way of doing my record set paging without the use of a dynamic LIMIT clause.

That's not to say we have it any worse--SQl Server doesn't have an easy way either, requiring the following:
--Pass in @RowMin and @RowMax as parameters--
-- columns being selected --
FROM (SELECT ROW_NUMBER() OVER
-- conditional statements --
AS RowNumber, vw_VehicleData.* FROM vw_VehicleData WHERE Vehicle_Year BETWEEN @YearLow AND @YearHigh, ETC
WHERE RowNumber between @RowMin AND @RowMax

Easy? no way.

Having this functionality would put us light years ahead of the big guys, and would make record set paging a breeze.

Please add it!