Concatenate two rows in SQL

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

ID                        EMAIL
_____________________________________________
EMAIL01                xxx.xxx
EMAIL01A                @xxx.com

Please help me to merge these two rows to create an email like this: xxx.xxx@xxx.com as a single row.

Posted 25-Feb-13 2:18am

mramukirs

Updated 25-Feb-13 5:24am

Mike Meinz

v3

Add a Solution

Comments

joshrduncan2012 25-Feb-13 9:21am

What have you tried so far to accomplish this task?

[no name] 25-Feb-13 9:57am

Have you tried "EMAIL01 + EMAIL01A"?

ZurdoDev 25-Feb-13 10:08am

As suggested, just concatenate them together into a single row. Where exactly are you stuck?

3 solutions

Add a Solution

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

Mike Meinz · Answer 1 · 2013-02-25T05:22:00

There is not enough information in the question to understand why a database table would be designed this way and what other rows are in the table that might need to be selected in a similar manner. Nevertheless, below is a Microsoft SQL Server SELECT statement that will concatenate the two rows in the manner that you specified in your question to create an email address.

Select (Select RTRIM(EMAIL) from table_1 where ID='EMAIL01') + (Select RTRIM(EMAIL) from table_1 where ID='EMAIL01A')

Note: Tested using Microsoft SQL Server Management Studio on SQL Server Express 2012

Prosan · Answer 2 · 2013-02-25T05:57:00

Solution 2

select (select ltrim(rtrim(Email)) from urTable where id='Email01') + (select ltrim(rtrim(Email)) from urTable where id='Email01A')
use this query

Posted 25-Feb-13 5:57am

Prosan

Chamadness · Answer 3 · 2013-02-25T06:00:00

Solution 3

Suppose your table is "THE_TABLE":

SQL

SELECT T1.ID, T1.EMAIL + T2.EMAIL FROM THE_TABLE T1 
  JOIN THE_TABLE T2 
     ON T2.ID = (T1.ID + 'A')

That should work ;)

Posted 25-Feb-13 6:00am

Chamadness

Updated 25-Feb-13 6:02am

v2

Concatenate two rows in SQL

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Concatenate two rows in SQL

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us