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 :-)

• Next in forum: Re: Things I didn't know until today
• Prev in forum: stored proc or something else
• Thread view: Things I didn't know until today

[Reply to this message]