How to divide groups in a single table?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

ID | name | Rollnumber| ... |...| ...| ...|
--------------------------------------------
1 vinod 101 _ _ _ _
2 shravan 102 _ _ _ _
3 ram 103
4 Teja 104
5 shekar 105
how divide groups in single table?
mens ID is one group
name and rollnumber 2nd group
.....

Posted 18-Dec-14 4:37am

iamvinod34

Add a Solution

Comments

Afzaal Ahmad Zeeshan 18-Dec-14 11:10am

You divide single tables into groups, not groups into single groups. Did you mean to merge?

iamvinod34 18-Dec-14 11:29am

yes,single tables into groups
plz tell . sql query and user click on button create table with groups divide
plz help sir

Maciej Los 18-Dec-14 14:33pm

Do not repost: How to create groups in one table sqlserver?[^]!!!
Rather improve your previous question.

I'd suggest to show us expected output.

Tomas Takac 18-Dec-14 16:56pm

Oh, a new post. Man I still have no idea what you are trying to achieve. Show us the expected results, as I already suggested in your previous post.

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)

Maciej Los · Answer 1 · 2014-12-18T08:47:00

Solution 1

Please, read my comment to the question.

If i understand you well...
If you want to return 2 columns, instead of 3, use this query:

SQL

SELECT ID AS FirstColumn, [name] + CONVERT(VARCHAR(10), rollnumber) AS SecondColumn
FROM TableName

Posted 18-Dec-14 8:47am

Maciej Los

Comments

Tomas Takac 18-Dec-14 16:57pm

+4 for the effort, this is as good guess as any

Maciej Los 18-Dec-14 16:57pm

Thank you, Tomas ;)