what does limit do?
if it limits the result set use top if you can, else
use "set rowcount n"
>we are migrating a huge application from mySQL to MSSQL.
>we are facing a huge problem because we are depending
>heavily on mySQL's LIMIT command in our sql select
>statements. nothing that we tried worked and we need a
>generic solution possibly a stored procedure unless there
>is a known solution to the problem. Any ideas/solutions?