Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 concatenate two fields with group by

Author  Topic 

boudake
Starting Member

3 Posts

Posted - 2015-05-01 : 10:08:45
Hello guys,
I have one table with three columns:
id,name,surname
1,djim,diop
1,boudake,fall
2,yacine,taph
2,diale,tol
I want have in my out table with two columns
ID Complet
1, name:djim name:boudake surname:diop surnaname:fall
2, name:yacine name:dial surname:taph surname:tol
Could you please help me to find a solution

Djim

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-05-02 : 09:23:32
Please see posting guidelines: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

also, please try to write the query first, then post what you have and what's not working

Gerald Britton
Toronto PASS Chapter
Go to Top of Page
   

- Advertisement -