|
|
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 :-)
>
Navigation:
[Reply to this message]
|