Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Nicolasb

    Retrieve row number X to row Y

    Hi Michael, In my case, I cannot use the TOP clause because my ORDER BY is not by uniqueID. Instead, I have written a store procedure. I'll post it here, maybe it will be usefull, someday, for another user. Thanx for you're answer, Nicolas - - - - - - - - - - /* Receive the number of the...
  2. Nicolasb

    Retrieve row number X to row Y

    Hi! My query: SELECT * FROM table Return 100 rows I want to retrieve records from row number 20 to row number 30... How can I do this? A select within a select? With variables? Thank you very much, Nicolas
  3. Nicolasb

    I want to retrieve row number X to row Y

    Hi! My query: SELECT * FROM table Return 100 rows I want to retrieve records from row number 20 to row number 30... How can I do this? Thank you very much, Nicolas

Part and Inventory Search

Back
Top