Posted by MC on 01/24/07 20:17

YOu can also use UPDATE TOP :)

MC

"amaxen" <Amaxen1@gmail.com> wrote in message
news:1169669614.239808.78900@v33g2000cwv.googlegroups.com...
> 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]