Problems with SQL

[Britney S Morales]

Im looking for a query who get result in packages let me explain select * from users where codgroup = 1 i get all the user belongs to group 1 (100 users) i want a query who get the rows by package (ten could be). PD: Only sql statements, not using paging gridview property I hope you can help me :sigh:

keep Learning and you never will be out of date...

[Member 96]

I'm not sure what this has to do with asp.net, perhaps try the correct forum which in this case would be the SQL one and you might have more luck. Also your question is a little unclear by what you mean by "packages".

[just3ala2]

Search for paging for your control. CodeProject has many controls for that

Best Regards 3ala2 :)

[ednrgc]

Forgive my ignorance, but I'm not sure I understand what you mean by packages. Are they physical packages, Oracle packages, or something else?

[Britney S Morales]

Somebody tell me that SELECT * FROM users LIMIT 0, 10 i could get the firsts ten registers, later i could use the sentence SELECT * FROM users LIMIT 11, 20, in order to get the 11 to 20 users data. But i doesnt work, :doh: did you get the idea???

keep Learning and you never will be out of date...

[ednrgc]

Since SQL Server does not have a limit clause, I'm assuming that you are using another backend database. What DB are you using?

[ednrgc]

It may also help to have a general database schema (don't include specific business data for security reasons) or a mock DB schema. I'm getting the feeling that your solution would be solved by an inner join with a TOP clause on the right side table.

[ednrgc]

You could try a stored procedure like the following: CREATE PROCEDURE [dbo].[usp_GetnRecordsForEachUser] ( @userID int, @maximumRows int ) AS SET ROWCOUNT @maximumRows SELECT u.* FROM users u WHERE userid = @userID ORDER BY u.userID SET ROWCOUNT 0 GO