Posted by amaxen on 01/24/07 20:13

You can use a Select top @variable in sql server 2005:

Thus:


--'Throttle' the result set:
Select Top (@MaxBatchSize)
KeyID
, LId
, ArrivalDt
, CaptureDt
, Lat
, Long
From GPSData
Order By CaptureDt Desc

Makes messing with Set Rowcount *so* redundant :-)

[Back to original message]