How to Merge two Rows into one in sql Server

Question

1.00/5 (1 vote)

See more:

SQL-Server

I would like to merge two rows into single row can any one help

Posted 18-Jul-12 2:04am

Anand Arul K

Add a Solution

Comments

Mario Majčica 18-Jul-12 8:13am

Make an example. Your question is not clear. What kind of merge are you trying to do?

4 solutions

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)

Arul R Ece · Answer 1 · 2012-07-18T19:57:00

Hi ...

Please see the below example.

SQL

CREATE TABLE #Temp
(
[Numbers] varchar(40)
)
INSERT INTO #Temp VALUES('One');
INSERT INTO #Temp VALUES('Two');
INSERT INTO #Temp VALUES('Three');
INSERT INTO #Temp VALUES('Four');
INSERT INTO #Temp VALUES('Five');

select * from #Temp

DECLARE @str VARCHAR(100)
SELECT @str = COALESCE(@str + '', '') + [Numbers]
FROM #Temp
Print @str

Zukiari · Answer 2 · 2012-07-18T20:43:00

Solution 3

Hi,

select col_name1 + '' + col_name2 from table_name

Posted 18-Jul-12 20:43pm

Zukiari

Aarti Meswania · Answer 3 · 2012-07-19T03:11:00

use Join

SQL

select tbl1.fld1 as t1_fld1,tbl1.fld2 as t1_fld2
,tbl2.fld1 as t2_fld1 ,tbl2.fld2 as t2_fld2
from
tbl1 
inner join tbl2 on tbl1.fld1=tbl2.fld1

tbl1
-------------
fld1   fld2
-------------
a      b
1      2  


tbl2
-------------
fld1   fld2
-------------
a      c
1      3


Result
---------------------------------------
t1_fld1   t1_fld2   t2_fld1   t2_fld2
---------------------------------------
a         b         a          c
1         2         1          3


two different tables rows are merged into single row using join

this way first & second tables' related rows will be shown as
single row in resultant table-set.

if you ask your question with example, then it will be more easy to understand.

Happy Coding!
:)

StianSandberg · Answer 4 · 2012-07-18T02:17:00

Solution 1

SQL

UPDATE Table SET MergedColumn = Column1+' - '+Colum2

Posted 18-Jul-12 2:17am

StianSandberg

Comments

Ainy Mughal 15-Apr-14 6:24am

this is to merger columns.

How to Merge two Rows into one in sql Server

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0