Sql server query problem

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi,

I have problem with an SQL query. I want to select five records from a table and assign it 1 and the next 5 records assign it 2 and next 5 records assign it 3, etc...

How could I accomplish this.

Thanks.

Posted 25-Oct-11 0:38am

mohd vaquas

Updated 25-Oct-11 0:58am

Slacker007

v2

Add a Solution

Comments

Herman<T>.Instance 25-Oct-11 6:41am

without any code it is hard to tell but I guess you need function to have a Row_Number?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ShacharK · Accepted Answer · 2011-10-25T01:01:00

Solution 1

SQL

UPDATE Table SET record = ( (id-1)/5+1 )

Did you mean something like that?
It assigns [1,5] to 1, [6,10] to 2, etc.

Posted 25-Oct-11 1:01am

ShacharK

Comments

Herman<T>.Instance 25-Oct-11 7:05am

nice thinking

mohd vaquas 25-Oct-11 7:09am

yes i need same as ...

how i can do like that can you please give me some more detail..

ShacharK 25-Oct-11 7:10am

So did it work for you?

mohd vaquas 25-Oct-11 7:16am

thanks for ur reply
update table set record=((id-1)/5+1

the above query what is the id?
can u please explain Little more

thanks

mohd vaquas 25-Oct-11 7:26am

select ceiling(ROW_NUMBER() OVER (Order by TotalSale desc)) AS rownumber, * from #tempTable2

when i run this query its give me the sequential Rownumber like 1,2,3,4,5,6,7,8,9........
i need one more column which store the 1 for 1 to 5 record and 2 for 6 to 10 records and so on......

please help me how can i achieve this result
thanks

ShacharK 25-Oct-11 7:36am

'id' should be the number of the line. The primary key, or something like that would do.

CREATE TABLE table (
id int PRIMARY KEY IDENTITY(1,1)
record int
)

Fill the table with some values... let the id get the designated IDENTITY value.

and then apply the UPDATE query that I've suggested.