Hi, I am using sqlserver2005 as my database.I am facing problem in when i give limit and offset in the query. Eg : @books=Book.find(:all, :limits=>1,:offset=>2 ) SELECT * FROM (SELECT TOP 1 * FROM (SELECT TOP 2 id,name FROM books WHERE ( status=''Approved'') ) AS tmp1 ) AS tmp2 query is executing like this...its not working...if any one knows how to use limits and offsets in sqlserver2005 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---