Please solve below sql query

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

I have data in table as below manner

Monthno m1    m2   m3
1       1     0    0
1       0     1    0
1       0     0    1
2       1     0    0
2       0     1    0

And I want change these data into look like below manner. Monthno column continues as same numbers and changed number will be inserted in same row again as new row

Monthno m1  m2     m3
1       1    1     1
2       1    1     0

[edit]Tabs to spaces for proper indentation[/edit]
[edit]Code block added - OriginalGriff[/edit]

Posted 14-Oct-14 2:49am

Burning Thoughts

Updated 14-Oct-14 3:03am

Manfred Rudolf Bihy

v4

Add a Solution

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)

OriginalGriff · Accepted Answer · 2014-10-14T03:00:00

Solution 1

Try:

SQL

SELECT MonthNo, SUM(M1) AS M1, SUM(M2) AS M2, SUM M3 AS M3 
FROM MyTable
GROUP BY MonthNo

Posted 14-Oct-14 3:00am

OriginalGriff

Comments

OriginalGriff 14-Oct-14 9:16am

Then you need to explain exactly what comprises "correct data" - we can't read your mind from here!

Burning Thoughts 14-Oct-14 9:17am

thank you its working .....